CREATE
TABLE
[dbo].[Person](
[Id] [
bigint
] IDENTITY(1,1)
NOT
NULL
,
[
Name
] [
varchar
](50)
NULL
,
[Address] [
varchar
](500)
NULL
,
CONSTRAINT
[PK_Person]
PRIMARY
KEY
CLUSTERED
(
[Id]
ASC
)
WITH
(PAD_INDEX =
OFF
, STATISTICS_NORECOMPUTE =
OFF
, IGNORE_DUP_KEY =
OFF
, ALLOW_ROW_LOCKS =
ON
, ALLOW_PAGE_LOCKS =
ON
)
ON
[
PRIMARY
]
)
ON
[
PRIMARY
]
GO
SET
ANSI_PADDING
OFF
GO
SET
IDENTITY_INSERT [dbo].[Person]
ON
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(1, N
'Ram'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(2, N
'Shyam'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(3, N
'Rahul'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(4, N
'Raj'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(5, N
'Shahrukh'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(6, N
'Amir'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(7, N
'Raju'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(8, N
'Rohit'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(9, N
'Raghu'
, N
'23, Delhi, India'
)
INSERT
[dbo].[Person] ([Id], [
Name
], [Address])
VALUES
(10, N
'Samir'
, N
'23, Delhi, India'
)
SET
IDENTITY_INSERT [dbo].[Person]
OFF