摘要:
1)禁止所有表约束的SQLselect'altertable'+name+'nocheckconstraintall'fromsysobjectswheretype='U'2)删除所有表数据的SQLselect'TRUNCATETABLE'+namefromsysobjectswheretype='U'3)恢复所有表约束的SQLselect'altertable'+name+'checkconstraintall'fromsysobjectswheretype='U' 阅读全文
posted @ 2011-07-08 13:12
dinoy
阅读(16778)
评论(0)
推荐(0)
浙公网安备 33010602011771号