摘要: select 'ALTER TABLE [' + b.name + '] NOCHECK CONSTRAINT ' + a.name +';' as 禁用约束 from sysobjects a ,sysobjects b where a.xtype ='f' and a.parent_obj = b.idselect 'ALTER TABLE [' + b.name + '] CHECK CONSTRAINT ' + a.name +';' as 启用约束 from sysobje 阅读全文
posted @ 2013-08-06 10:40 Grok.Yao 阅读(365) 评论(0) 推荐(0) 编辑