摘要： 使用临时表：select id=identity(int,1,1),value into #temp from YourTable select * from #temp drop table #temp 取得第11到20行记录：select IDENTITY(int,... 阅读全文

摘要： --获得禁用所有外键约束的语句select 'ALTER TABLE [' + b.name + '] NOCHECK CONSTRAINT ' + a.name +';' as 禁用约束 from sysobjects a ,sysobjects b where a.xtype ='f' and ... 阅读全文