Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Caronas
CREATE TABLE MOTORISTAS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, num_registro CHAR(12) NOT NULL, med_aval FLOAT NOT NULL, PRIMARY KEY(id)); CREATE TABLE PASSAGEIROS( id CHAR(8) NOT NULL, nome VARCHAR(60) NOT NULL, PRIMARY KEY(id)); CREATE TABLE VIAGENS( motorista_id CHAR(8) NOT NULL, passageiro_id CHAR(8) NOT NULL, data_inicio TIMESTAMP NOT NULL, km_rodados INT, FOREIGN KEY (motorista_id) REFERENCES MOTORISTAS, FOREIGN KEY (passageiro_id) REFERENCES PASSAGEIROS);
run
|
edit
|
history
|
help
0
Comercio
Rename column name using 'sp_rename' command
Генерация чисел в диапазоне в MS SQL
Student
SQL Directives Order of Execution
omnichannel_example
Import CSV File Into SQL Server Using Bulk Insert
Trabalho.Agrecação
SQL Server - regex filtering using LIKE
emp