Aliendreamer

sql drama dbo.people

May 25th, 2018
167
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.64 KB | None | 0 0
  1. CREATE TABLE People
  2. (
  3.  [Id] INT PRIMARY KEY IDENTITY,
  4.  [Name] VARCHAR(200) NOT NULL,
  5.  [Picture] VARBINARY(MAX),
  6.  [Height] DECIMAL(5,2),
  7.  [Weight] DECIMAL(5,2),
  8.  [Gender] CHAR NOT NULL CHECK(Gender='m' OR Gender='f'),
  9.  Birthdate DATE NOT NULL,
  10.  Biography NVARCHAR(MAX)
  11. )
  12. GO
  13. INSERT INTO People(Name,Picture,Height,Weight,Gender,Birthdate,Biography) VALUES
  14. ('Stela',NULL,1.65,44.55,'f',22/09/2000,NULL),
  15. ('Ivan',NULL,2.15,95.55,'m',02/11/1989,'god i hate judge'),
  16. ('Qvor',NULL,1.55,33.00,'m',31/04/2010,'Can i bomb it?'),
  17. ('Karolina',NULL,2.15,55.55,'f',22/09/2001,'I want to get drunk'),
  18. ('Pesho',NULL,1.85,90.00,'m',22/07/1983,'goldfinger')
Advertisement
Add Comment
Please, Sign In to add comment