Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE People
- (
- [Id] INT PRIMARY KEY IDENTITY,
- [Name] VARCHAR(200) NOT NULL,
- [Picture] VARBINARY(MAX),
- [Height] DECIMAL(5,2),
- [Weight] DECIMAL(5,2),
- [Gender] CHAR NOT NULL CHECK(Gender='m' OR Gender='f'),
- Birthdate DATE NOT NULL,
- Biography NVARCHAR(MAX)
- )
- GO
- INSERT INTO People(Name,Picture,Height,Weight,Gender,Birthdate,Biography) VALUES
- ('Stela',NULL,1.65,44.55,'f',22/09/2000,NULL),
- ('Ivan',NULL,2.15,95.55,'m',02/11/1989,'god i hate judge'),
- ('Qvor',NULL,1.55,33.00,'m',31/04/2010,'Can i bomb it?'),
- ('Karolina',NULL,2.15,55.55,'f',22/09/2001,'I want to get drunk'),
- ('Pesho',NULL,1.85,90.00,'m',22/07/1983,'goldfinger')
Advertisement
Add Comment
Please, Sign In to add comment