Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Creation tables
create table Person_Edige1 ( DriverID int primary key, address varchar(255), Name varchar(255) ) create table Car_Edige1( License int, PersonDriverID int, Model varchar(255), Year int ) create table CarAccident_Edige1( CarLicense int, AccidentReportNum int, DamageAmount numeric(19,0) ) create table Accident_Edige1( ReportNum int, Location varchar(255), AccidentDate datetime )/* alter table Car_Edige add constraint FK_Car_Edige_Person_Edige foreign key(PersonDriverID) references Person_Edige(DriverID) */
run
|
edit
|
history
|
help
0
Use the right tool to get identity values back after an insert
updated
Libros
Teacher
Manish SQL
Caronas
SQL Server - Multiple Holidays Model
StackOverflow_53575163
UNPIVOT
megha