This is a good query to fetch comma separated data using XML Path.

Find procedure and function from this query.

Interesting thing in code to add one field in table once the table is already in the database.

How to Create a Backup Job in SQL Server.

In this blog, you will see how to use Ntile function in SQL Server.

SQL Server 2012 comes with a different Editions with adding diffrent feature,in this blog i will explain the diffrent types of SQL Server 2012 Editions.

Sometimes their is need to update the existing table in sql server database such as to add, remove column of existing table or change the size or type of data type of table Column. This article is ...

This SQL query analyzes the Persons table to determine the frequency distribution of ages. It counts the occurrences of each age and orders them in descending order of frequency.

Here, I am discussing only two data type date and time.

Hare, I give you an Example of Dynamic Stored Procedure with output parameter.

Split Column in to or more column.

This blog shows the difference between temp table and global temp table

User defined data types created on the basis of system data types.

In this blog I try to take backup of all databases using ‘sp_MSforeachdb’ procedure.

In this blog, we will see how do we merge 2 rows values separated with comma in SQL.

This code snippet splits string.

Bitwise operators are very efficient. It allows us to hold conditional logic in an integer column.

In this blog let us see how to add identity property for the existing column in a table which already has rows.

Here, We will see how to handle null values in DataTable's in DateTime column using SQL DateTime DataType.

This blog demonstrate how to use PIVOT table in sql server.