游标暂停和启用外键约束foreignkey

---------暂停外键约束
declare @Sql nvarchar(200);
declare mycursor cursor for (select  'ALTER TABLE ['  + b.name +  '] NOCHECK CONSTRAINT ' +  a.name +';'   
from  sysobjects  a ,sysobjects  b    
where  a.xtype ='f' and  a.parent_obj = b.id)
open mycursor
fetch next from mycursor into @Sql
while(@@fetch_status = 0)
begin
	exec(@Sql)
	fetch next from mycursor into @Sql;
end
close mycursor
deallocate mycursor


---------启动外键约束
declare @Sql nvarchar(200);
declare mycursor cursor for (select  'ALTER TABLE [' + b.name +  '] CHECK CONSTRAINT ' +  a.name +';'  
from  sysobjects  a ,sysobjects  b    
where  a.xtype ='f' and  a.parent_obj = b.id)
open mycursor
fetch next from mycursor into @Sql
while(@@fetch_status = 0)
begin
	exec(@Sql)
	fetch next from mycursor into @Sql;
end
close mycursor
deallocate mycursor