平常用的上的一些SQL

简单统计表信息

create table #temp
(name varchar(255),
 rowcnt int,
 reserved varchar(20),
 data varchar(20),
 idx_size varchar(20),
 unused varchar(20))
exec sp_MSforeachtable "insert into #temp exec sp_spaceused '?'"
select * from #temp
drop table #temp

杀掉数据库进程

Create Proc proc_KillDeadlockSPID
@DBName varchar(50)
As
Begin
use master
Declare @Sql nvarchar(max)
Declare @SPID int
Declare cur Cursor For Select SPID From SysProcesses Where DBID=DB_ID(@DBName)
Open cur
Fetch Next From cur Into @SPID
While @@Fetch_Status=0
BEGIN
Set @Sql='kill '+rtrim(@SPID)
exec(@Sql)
Fetch Next From cur Into @SPID
END
Close cur
Deallocate cur
End