SQL SERVER: Function to check column exists in table or not?

Introduction :   In this article I am going to explain how to check whether column exists in table or not; if not only then add the column....

Sql Server: User Defined Function to Get All Dates Between Two Dates

Introduction : In this short article I am going to share how to create a table valued user defined function to get all dates between speci...

Convert or split comma separated string into table rows in Sql server

Introduction : In this article I am going to share how to convert or split large comma separated string into table rows using our own crea...

Find all or any Sql Server Table,View,Stored Procedure,User Defined Function and Schema in a database

Introduction :   In this short article I am going to share sql server commands/queries   to get or check all or specific schemas, tables, ...

Multiple Sql server queries to find all User Defined Functions (UDF’s) in a database

Introduction :   In this short article I am going to share sql server commands/statements to get or check all user defined functions i.e. ...