Create database to test Queries of this blog..........

Run this script:

CREATE DATABASE dbTest;

CREATE TABLE Person

(

pid INT IDENTITY(1,1),

name VARCHAR(200) NOT NULL,

dob DATETIME NULL,

occupation varchar(100) NULL,

address VARCHAR(200),

city VARCHAR(100),

state VARCHAR(100),

isBlock BIT,

PRIMARY KEY(PID)

)

USE [dbTest]

GO

/****** Insert Data into Person table   ******/

SET IDENTITY_INSERT [dbo].[Person] ON

INSERT [dbo].[Person] ([pid], [name], [dob], [occupation], [address], [city], [state], [isBlock]) VALUES (1, N'Abhishek', CAST(0x00007A1B00000000 AS DateTime), N'Student', N'E-56', N'Delhi', N'Delhi', 0)

INSERT [dbo].[Person] ([pid], [name], [dob], [occupation], [address], [city], [state], [isBlock]) VALUES (2, N'Ram', CAST(0x00006E2500000000 AS DateTime), N'DBA', N'PritVihar', N'Lucknow', N'U.P.', 0)

INSERT [dbo].[Person] ([pid], [name], [dob], [occupation], [address], [city], [state], [isBlock]) VALUES (3, N'Abhijit', CAST(0x00007E8300000000 AS DateTime), N'J.DBA', N'', NULL, NULL, 1)

SET IDENTITY_INSERT [dbo].[Person] OFF