常用SQL语句

  --随机选取10条记录
  SELECT top 10 * FROM authors a ORDER BY NEWID()
  --列出数据库里的所有表名
  SELECT NAME FROM sysobjects WHERE [type]='U'
 --增加一个列
 ALTER TABLE tb1 ADD FirstName VARCHAR(50)
 --增加列并设置默认值
  ALTER TABLE tb1 ADD LastName VARCHAR(50) CONSTRAINT LastName DEFAULT 'JAMES' WITH VALUES
  --复制表，仅复制表结构
  select * into b from a where 1<>1
  --完全复制，结构+数据
  Select * into tableB from tableA
  --列出表里的所有列名
  SELECT * FROM syscolumns WHERE id=[table_id]
  --N到M条记录(要有主索引ID)
  SELECT TOP 5 * FROM authors a WHERE a.au_id NOT IN (SELECT TOP 10 au_id FROM authors a)  ORDER BY a.au_id ASC
 SELECT * FROM sysobjects s
-- N到M条记录(要有主索引ID)
Select Top M-N * From 表 Where ID in (Select Top M ID From 表) Order by ID   Desc