Advertisement
Aliendreamer

people table

May 26th, 2018
892
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.60 KB | None | 0 0
  1. CREATE TABLE People
  2. (
  3.  [Id] INT PRIMARY KEY Identity,
  4.  [Name] NVARCHAR(200) NOT NULL,
  5.  [Picture] VARBINARY(MAX),
  6.  [Height] DECIMAL(5,2),
  7.  [Weight] DECIMAL(5,2),
  8.  [Gender] char(1) Not null CHECK(Gender='m' OR Gender='f'),
  9.  Birthdate DATE Not Null,
  10.  Biography NVARCHAR(MAX)
  11. )
  12. INSERT INTO People(Name,Picture,Height,Weight,Gender,Birthdate,Biography) Values
  13. ('Stela',Null,1.65,44.55,'f','2000-09-22',Null),
  14. ('Ivan',Null,2.15,95.55,'m','1989-11-02',Null),
  15. ('Qvor',Null,1.55,33.00,'m','2010-04-11',Null),
  16. ('Karolina',Null,2.15,55.55,'f','2001-11-11',Null),
  17. ('Pesho',Null,1.85,90.00,'m','1983-07-22',Null)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement