Advertisement
Guest User

Untitled

a guest
Aug 18th, 2019
76
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.48 KB | None | 0 0
  1. CREATE DATABASE Linguagens
  2. GO
  3.  
  4. USE Linguagens
  5. GO
  6.  
  7. CREATE TABLE dbo.Linguagens
  8. (
  9. Codigo char(3) NOT NULL,
  10. Nome varchar(30) NOT NULL,
  11. SalarioJr numeric (8,2) NOT NULL,
  12. SalarioPleno numeric (8,2) NOT NULL,
  13. SalarioSenior numeric (8,2) NOT NULL
  14. CONSTRAINT PK_Linguagens PRIMARY KEY (Codigo)
  15. )
  16. GO
  17.  
  18. INSERT INTO dbo.Linguagens
  19. (
  20. Codigo
  21. ,Nome
  22. ,SalarioJr
  23. ,SalarioPleno
  24. ,SalarioSenior
  25. )
  26. VALUES
  27. (
  28. 'RCT'
  29. ,'React'
  30. ,2500.00
  31. ,4000.00
  32. ,1000.00
  33. )
  34. GO
  35.  
  36. SELECT * FROM dbo.Linguagens
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement