施情化忆

摘要： 一、SQL 禁用、开启表的所有约束--禁用所有约束exec sp_msforeachtable "alter table ? nocheck CONSTRAINT all"--再启用所有外键约束exec sp_msforeachtable "alter table ? check constraint all"二、获取一个表的行/列select count(*) from tbTestWellBasicInfoselect count(a.name) as count from syscolumns a where a.id=object_id(' 阅读全文