Sql

Search

SQL Server lock table example

SELECT
OBJECT_NAME(p.OBJECT_ID) AS TableName,
resource_type, resource_description
FROM
sys.dm_tran_locks l
JOIN sys.partitions p ON l.resource_associated_entity_id = p.hobt_id

Comment

PREVIOUS	NEXT

Code Example
Sql :: laravel jwt
Sql :: update with join
Sql :: eliminate zero from integer mysql
Sql :: mariadb hours between two dates
Sql :: spring data.sql table not found
Sql :: varchar vs nvarchar sql
Sql :: postgresql append array
Sql :: add a day big query
Sql :: sql datetime format dd/mm/yyyy hh:mm am/pm
Sql :: sp in sql server
Sql :: null sql
Sql :: The local psql command could not be located
Sql :: run postgresql dump to csv
Sql :: how to uninstall postgresql 13 on mac
Sql :: 3rd highest value in sql
Sql :: wherein sql
Sql :: sql create database
Sql :: xampp mysql version
Sql :: json with root element in sql server
Sql :: sql select count distinct
Sql :: sql select rows with different values in one column
Sql :: mysql date equals to current_date plus days
Sql :: mysql delete data in table
Sql :: calculate percentage in sql
Sql :: Write an SQL query to print details of the Workers whose FIRST_NAME ends with ‘a’.
Sql :: drop schema sql
Sql :: how to select random rows from table
Sql :: install latest mysql 8 linux server
Sql :: how to get initials in sql
Sql :: postgres order by month

Search

SQL

SQL Server lock table example

ADD CONTENT