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
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