Useful functions in SQL Server

Useful functions in SQL Server

I love SQL Server and the productivity we used to get in SQL Server. It has so many useful function which increase the productivity of SQL Developer. Today is Sunday and Indian holiday “Navratri” is just over so don’t want to give heavy dose to blog reader rather I want to brush up memory with some of my favorite and useful SQL Server function.

There are hundreds of functions available in SQL Server and out of those functions I have some of my favorite functions which are part of my routine life.

So here we go with the list of SQL Server functions:

Function Link to learn
CHOOSE Click Here
LEAD Click Here
LEG Click Here
CUME_DIST Click Here
PERCENT_RANK Click Here
LAST_VALUE Click Here
FIRST_VALUE Click Here
EOMONTH Click Here
DATEADD Click Here
DATEFROMPARTS Click Here
DATETIMEFROMPARTS Click Here
TIMEFROMPARTS Click Here
PARSE Click Here
TRY_PARSE Click Here
TRY_CONVERT Click Here
ISNULL Click Here
COALESCE Click Here
CONCAT_NULL_YIELDS_NULL Click Here

Now last but not least, SPLIT function. Actually we need to split values based on different separator, SQL Server doesn’t support any SPLIT function by default so  I have created my own user defined SPLIT function. Click here to use the script.

If you like this article, do like “Extreme-Advice” page in Facebook.

Reference: Ritesh Shah

http://Extreme-Advice.com

http://www.sqlhub.com

Note: Microsoft Books online is a default reference of all articles.