Important queries
To check database locks
To execute stored procedure
To view stored procedure
To execute insert command with ids
To execute query without locking
SQL Commands
Popular posts from this blog
Sql Query Execution Order
From Join Where Group By Having Select Order By Limit
DateTime Functions
GETDATE() DATEADD() DATEDIFF() DATEPART() Datename() NOW() CURRENTDATE() CURRENTTIME() DATE() EXTRACT() CONVERT() FORMAT() Day() Month() Year() Sysdatetime() Sysdatetimeoffset() Sysutcdatetime() Gettutdate() Switchoffset() Todatetimeoffset() CurrentTimeStamp()
Comments
Post a Comment