SQL Server

How to Get data in XML format from SQL Server?

This tutorial will explain you how to get data in XML format from SQL server database. To get data in […]

Updated on     Kisan Patel

Create Temporary Table in SQL Server

This tutorial will show you how to temporarily hold data into temporary table in SQL Server? Temporary table is similar […]

Updated on     Kisan Patel

Create Table Variable in SQL Server

This tutorial will show you how to temporarily hold data into table variable in SQL Server? DECLARE @InactiveRecords AS TABLE […]

Updated on     Kisan Patel

Difference between Primary Key and Unique Key

This tutorial will explain you what is the difference between primary key and unique key. In SQL Server, we have […]

Updated on     Kisan Patel

How to use CASE statement to set a variable value in SQL Server?

This tutorial will show you how to use CASE statement to set a variable value in SQL Server? DECLARE @cId […]

Updated on     Kisan Patel

Use CASE statement with ORDER BY clause in SQL Server

This tutorial will show you how to use CASE statement with ORDER BY clause in SQL Server? To do this, […]

Updated on     Kisan Patel

Using CASE statement in SQL Server

This tutorial will show you how to use CASE statement to check a value of the column in SQL Server? […]

Updated on     Kisan Patel

WHILE loop in SQL Server

This tutorial will show you how to use WHILE loop in SQL Server? Similar to IF condition, WHILE loop is […]

Updated on     Kisan Patel

IF condition in SQL Server

This tutorial will show you how to use IF condition in SQL Server? If condition works in SQL server in […]

Updated on     Kisan Patel

Get more Details About Error Occurred in SQL Server

This tutorial will show you how to get more details about an error occurred in SQL Server? To get more […]

Updated on     Kisan Patel