SQL

Sometime we need to split a comma separated string to a Table of integers.  The below function will split the given comma-separated string ...

This SQL stored procedure will allow you to write to the file on your system where SQL Server is running. If you are using this with your l...

sys.databases : Lists all the databases in Sql Server. sys.tables : Lists all the Tables in the database. sys.views : Lists all the view...

There are various techniques to determine whether a given year is a leap year. You can use the below SQL function to check for leap year: ...

Sometimes after massive changes in MSSQL database, there is a need to recompile all stored procedures, user-defined functions and views in ...