1、列出数据库里所有的表名
select name from sysobjects where type='U'
2、列出表里的所有的元素
select name from syscolumns where id=object_id('TableName')
3、随机取出10条数据
select top 10 * from tablename order by newid()
4、随机选择记录
select newid()
5、删除重复记录
Delete from tablename where id not in (select max(id) from tablename group by col1,col2,...)
6、预定日程提前五分钟提醒
select * from 日程安排 where datediff('minute',f开始时间,getdate())>5
7、拷贝表(拷贝数据,源表名:a 目标表名:b) (适用于Access)
insert into b(a, b, c) select d,e,f from b;
8、复制表(只复制结构,源表名:a 新表名:b) (适用于Access)
法一:select * into b from a where 1<>1
法二:select top 0 * into b from a
9、跨数据库之间表的拷贝(具体数据使用绝对路径) (Access可用)
insert into b(a, b, c) select d,e,f from b in ‘具体数据库’ where 条件
例子:..from b in '"&Server.MapPath(".")&"/data.mdb" &"' where..