摘要:
sp_dboption 'databasename','Single User','True' -- 设置数据库为单用户类型 dbcc checkdb('databasename',REPAIR_ALLOW_DATA_LOSS)with ALL_ERRORMSGS sp_dboption 'data 阅读全文
摘要:
① select count(1) from syscolumns where id=object_id('tablename') ② select count(*) from syscolumns where id=object_id('tablename') ③ select max(colid 阅读全文