This tutorial will explain you how to return records in Group by a column value with HAVING and WHERE clause in […]

In this tutorial, we have list out the sql server data type with its range. To store any kind of […]

In this tutorial, you will learn how to create computed column in sql server? To create a computed column in […]

This tutorial will explain you what is view and how to create view in SQL Server. A view in sql server […]

To get a random unique value (Guid – Globally Unique Identifier) in SQL Server, we use NEWID function. SELECT NEWID() […]

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

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

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

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

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