Inbuilt functions
Cast
ToString()
GetRoot()
GetDescendant()
IsDescendantOf()
GetLeveI()
GetAncestor()
GetReparentedValue()
RANK()
DENSE_RANK()
ROUND()
Rownumber
CTE
Temperory Table
patindex()
Textptr()
Textvalid()
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