复制表 select * into Users2 from Users 将Users表的结构,内容复制到Users2 (Users2 还未创建)
随机取出10条数据 select top 10 * from tablename order by newid()
列出数据库里所有的表名 select name from sysobjects where type='U'
CopyRight © 2010-2021 脚本学堂 Jb200.com , All Rights Reserved.