update语句中使用表别名:
update A set A.ID = 'xxxx' from TableA A
查找占用数据库的进程:
declare @kid varchar(8000)
set @kid=''
select @kid=@kid+' kill '+cast(spid as varchar(8))
from master..sysprocesses
where dbid=db_id('DBname')
print @kid
Exec(@kid)
update语句中使用表别名:
update A set A.ID = 'xxxx' from TableA A
查找占用数据库的进程:
declare @kid varchar(8000)
set @kid=''
select @kid=@kid+' kill '+cast(spid as varchar(8))
from master..sysprocesses
where dbid=db_id('DBname')
print @kid
Exec(@kid)
转载于:https://www.cnblogs.com/songsz1/archive/2012/12/12/2814260.html