wingman007

SQLServerManualDump

Nov 17th, 2014
265
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.71 KB | None | 0 0
  1. CREATE DATABASE [WebApplicationDB]
  2. USE [WebApplicationDB]
  3. CREATE TABLE Users
  4. (
  5. user_id SMALLINT PRIMARY KEY,
  6. username VARCHAR(15) NOT NULL,
  7. password VARCHAR(15) NOT NULL,
  8. email VARCHAR(20) NOT NULL
  9. )
  10. INSERT INTO Users(user_id,username,password,email)
  11. VALUES (1,'Lilyana','Lilyanapass','lilinka_13@abv.bg')
  12. INSERT INTO Users(user_id,username,password,email)
  13. VALUES (2,'Ivaylo','Halachev','Ivaylo@abv.bg')
  14. INSERT INTO Users(user_id,username,password,email)
  15. VALUES (3,'Nikoleta','Petrova','Niki_Petrova@abv.bg')
  16. INSERT INTO Users(user_id,username,password,email)
  17. VALUES (4,'Danica','Andreeva','Dani_123@abv.bg')
  18. INSERT INTO Users(user_id,username,password,email)
  19. VALUES (5,'Gergana','Petkova','Geri_876@abv.bg')
Add Comment
Please, Sign In to add comment