Guest User

Untitled

a guest
Sep 26th, 2018
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.73 KB | None | 0 0
  1. create database dw_example2
  2. -----------------------------
  3. use dw_example2
  4. -----------------------------
  5. create table articles(
  6. id int primary key,
  7. name nvarchar(50),
  8. provider int,
  9. category int,
  10. price money,
  11. categoryName nvarchar(30)
  12. )
  13. ----
  14. delete from articles;
  15. ----------------
  16. create table articles2(
  17. id int primary key,
  18. name nvarchar(50),
  19. provider int,
  20. category int,
  21. price money,
  22. categoryName nvarchar(30)
  23. )
  24. ---------------------
  25. create table articles3(
  26. id int primary key,
  27. name nvarchar(50),
  28. provider int,
  29. category int,
  30. price money,
  31. categoryName nvarchar(30)
  32. )
  33. -------------------------
  34. create table articles4(
  35. id int primary key,
  36. name nvarchar(50),
  37. provider int,
  38. category int,
  39. price money,
  40. categoryName nvarchar(30)
  41. )
  42. ---select * from articles;
Add Comment
Please, Sign In to add comment