MS SQL锁表,查看被锁的表的sql语句

来源:互联网 发布:招聘软件哪个好 编辑:程序博客网 时间:2024/05/22 14:45
SELECT count(1) as cFROM (SELECT OBJECT_NAME(resource_associated_entity_id, resource_database_id) as objectnameFROM sys.dm_tran_locksWHERE resource_type = 'OBJECT' ) as tWHERE t.objectname = ?
0 0
原创粉丝点击