sqlserver查询锁住sql以及解锁的方法

SELECT

    request_session_id spid,

    OBJECT_NAME(

        resource_associated_entity_id

    ) tableName

FROM

    sys.dm_tran_locks

WHERE

    resource_type = 'OBJECT'

ORDER BY request_session_id ASC

--spid   锁表进程

    --tableName   被锁表名