SELECT count(1) as c
FROM (
SELECT OBJECT_NAME(resource_associated_entity_id, resource_database_id) as objectname
FROM sys.dm_tran_locks
WHERE resource_type = 'OBJECT' ) as t
WHERE t.objectname = ?
MS SQL锁表,查看被锁的表的sql语句
最新推荐文章于 2024-08-22 09:21:07 发布