wingman007

SQLServerManualDump

Nov 17th, 2014
456
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','[email protected]')
  12. INSERT INTO Users(user_id,username,password,email)
  13. VALUES (2,'Ivaylo','Halachev','[email protected]')
  14. INSERT INTO Users(user_id,username,password,email)
  15. VALUES (3,'Nikoleta','Petrova','[email protected]')
  16. INSERT INTO Users(user_id,username,password,email)
  17. VALUES (4,'Danica','Andreeva','[email protected]')
  18. INSERT INTO Users(user_id,username,password,email)
  19. VALUES (5,'Gergana','Petkova','[email protected]')
Add Comment
Please, Sign In to add comment