摘要：/* */--查看所有表名： select name from sysobjects where type='U' --查询表的所有字段名： Select name from syscolumns Where ID=OBJECT_ID('表名')/* */SELECT (case when a.colorder=1 then d.name else '' end) as 表名,--如果表名相同就返回空 a.colorder as 字段序号, a.name as 字段名, (case when COLUMNPROPERTY( a.id,a.... 阅读全文

摘要：Softwareversion:MicrosoftSQLServer2005-9.00.1399.06Sql.sql:insertintoTao.dbo.C(CNO,CNAME)values(900,'AAA')注：对象名使用完全限定名，即database.schema.object(table),如Tao.dbo.C否则会报错。batch.bat:@ECHOOFF@title恢复数据库脚本osql-E-S"ComputerName"-i"Sql.sql" SETtable=Tao.dbo.Cosql-E-q"select*fr 阅读全文