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: Generate Row Number/Serial Number with each row.

Introduction:  In this article i am going to explain how to generate row number or we can say serial number with the result set returned ...

Using MERGE in SQL Server to Insert, Update and Delete in Single Statement

Introduction:  In this article I am going to explain what is MERGE Statement in SQL and How to perform insert, update and delete operatio...