摘要:
select request_session_id spid, OBJECT_NAME(resource_associated_entity_id) tableName from sys.dm_tran_locks where resource_type='OBJECT' kill 59 阅读全文
摘要:
use pubs go declare @count int declare @sql nvarchar(4000) set @sql='select @count=count(*) from titles' exec sp_executesql @sql,N'@count int output', 阅读全文