Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql server list locks

SELECT resource_type, request_mode, resource_description
FROM sys.dm_tran_locks
WHERE resource_type <> ‘DATABASE’
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql on update current_timestamp 
Sql :: sql mm/dd/yyyy format 
Sql :: mysql delete all except 
Sql :: postgres concat 
Sql :: select nextval from sequence sql 
Sql :: like in mysql 
Sql :: datediff 
Sql :: cursor.execute in python sqlite3 
Sql :: update query in sql server 
Sql :: how to create a table in mysql 
Sql :: mysql command not working in linux 
Sql :: mysql replace remove html tag 
Sql :: sql current timestamp table 
Sql :: current date in postgresql minus 1 day 
Sql :: remove unique key from a table 
Sql :: how to run mysql on terminal mac 
Sql :: date sql get the last week count 
Sql :: drop temp table if exists 
Sql :: jwt laravel 
Sql :: postgres regular expression replace 
Sql :: rename a table in sql server 
Sql :: ascending order and where in sql 
Sql :: how to inner join 4 tables in sql 
Sql :: adding constraints to columns SQL 
Sql :: SQL Greater Than or Equal to Operator 
Sql :: get primary key of last inserted record sql server 
Sql :: Get first name and last name from full name string in SQL 
Sql :: oracle index hint 
Sql :: sql server last 2 days 
Sql :: query by column for substring sql 
ADD CONTENT
Topic
Content
Source link
Name
1+8 =