use master   go        declare @dbname sysname   set @dbname = 'chhai' --这个是要删除的数据库库名    /*****用游标杀死进程*****/     declare @s nvarchar(1000)   declare tb cursor local  for     select s = 'kill   ' + cast(spid as varchar)     from   master.dbo.sysprocesses     where  dbid = DB_ID(@dbname)         open   tb     fetch   next   from   tb   into   @s   while @@fetch_status = 0 begin     exec (@s)      fetch next from tb into @s end   close   tb   deallocate   tb     /*****删除数据库*****/ exec ('drop   database   [' + @dbname + ']')