Skip to content

Instantly share code, notes, and snippets.

@wendreof
Last active August 7, 2019 17:28
Show Gist options
  • Save wendreof/976cc3b504b4529fef7875a47f5a09ca to your computer and use it in GitHub Desktop.
Save wendreof/976cc3b504b4529fef7875a47f5a09ca to your computer and use it in GitHub Desktop.
Create DB and Table
CREATE DATABASE Linguagens
GO
USE Linguagens
GO
CREATE TABLE dbo.Linguagens
(
Codigo char(3) NOT NULL,
Nome varchar(30) NOT NULL,
SalarioJr numeric (8,2) NOT NULL,
SalarioPleno numeric (8,2) NOT NULL,
SalarioSenior numeric (8,2) NOT NULL
CONSTRAINT PK_Linguagens PRIMARY KEY (Codigo)
)
GO
INSERT INTO dbo.Linguagens
(
Codigo
,Nome
,SalarioJr
,SalarioPleno
,SalarioSenior
)
VALUES
(
'RCT'
,'React'
,2500.00
,4000.00
,1000.00
)
GO
SELECT * FROM dbo.Linguagens
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment