andy_tigger

摘要： //查询所有用户表 select * FROM sysobjects WHERE type='U' ORDER BY name select * from sys.tablesselect a.name AS '字段名',b.name AS '类型',a.length AS '长度' from syscolumns a LEFT JOIN systypes b ON a.xtype=b.xuser... 阅读全文

摘要： ALTER DATABASE 数据库名 SET MULTI_USER;USE master;GODECLARE @SQL VARCHAR(MAX);SET @SQL=''SELECT @SQL=@SQL+'; KILL '+RTRIM(SPID)FROM master..sysprocessesWHERE dbid=DB_ID('数据库名');EXEC(@SQL);GO 阅读全文