Create a sample database

CREATE DATABASE [ListExDb] 
GO
use [ListExDb]

GO 
CREATE TABLE [dbo].[Person](
    [IdNumber] [bigint] NOT NULL,
    [FirstName] [varchar](150) NULL,
    [Surname] [varchar](150) NULL,
    [Age] [int] NULL,
 CONSTRAINT [PK_Person_1] PRIMARY KEY CLUSTERED 
(
    [IdNumber] 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
INSERT INTO Person(IdNumber, FirstName, Surname, Age)
VALUES(123456,'Peter','Pan',42)
Go
INSERT INTO Person(IdNumber, FirstName, Surname, Age)
VALUES(654321,'John','Doe',31)
GO
INSERT INTO Person(IdNumber, FirstName, Surname, Age)
VALUES(987456,'Michael','Good',65)



Last edited Dec 15, 2010 at 6:23 AM by Caprisoft, version 4

Comments

No comments yet.