摘要:
http://www.cnw.com.cn/software-database/htm2013/20131018_284787.shtml 阅读全文
摘要:
1)禁止所有表约束的SQLselect 'alter table '+name+' nocheck constraint all' from sysobjects where type='U'2)删除所有表数据的SQLselect 'TRUNCATE TABLE '+name from sysobjects where type='U'3)恢复所有表约束的SQLselect 'alter table '+name+' check constraint all' from sysobj 阅读全文