SQl(MSSQL/SSQL)

 GETDATE() DATEADD() DATEDIFF() DATEPART() Datename() NOW() CURRENTDATE() CURRENTTIME() DATE() EXTRACT() CONVERT() FORMAT() Day() Month() Year() Sysdatetime() Sysdatetimeoffset() Sysutcdatetime() Gettutdate() Switchoffset() Todatetimeoffset() CurrentTimeStamp()

 From  Join Where Group By Having  Select  Order By  Limit

 Cast ToString() GetRoot() GetDescendant() IsDescendantOf() GetLeveI() GetAncestor() GetReparentedValue() RANK() DENSE_RANK() ROUND() Rownumber CTE Temperory Table patindex() Textptr() Textvalid()

 To check database locks To execute stored procedure  To view stored procedure  To execute insert command with ids To execute query without locking 

 SUBSTRING() LEFT() LEN() MID() LCASE() UCASE() Ascii() Char() Charindex() Difference() Left() Len() Lower() Ltrim() Nchar() Patindex() Quotename() Replace() Replicate() Reverse() Right() Rtrim() Soundex() Space() Str() String_Split() Stuff() Substring() Unicode() Upper() Trimo ConcatWs()

 Primary key  Foreign key Not Null Default  Check  Unique  Index