Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
Employee database
--Sql Server 2014 Express Edition --Batches are separated by 'go' select @@version as 'sql server version' create table employee ( lname varchar(20) not null, fname varchar(20) not null, ssn varchar(9), superssn varchar(9), bdate date, dno varchar(1), primary key (ssn) , --foreign key (superssn) references employee(ssn) --foreing key (dno) references department(dnumber) );
run
|
edit
|
history
|
help
0
2021-03-09_LeetCodeSQL
Turn comma-separated numbers in string into rows
[SQLS]-Split and update a column
MERGE WITH OUTPUT
SQL query to find difference in text between different rows
Employye
gfhrey
QUAN LY MAYBAY
SQL_BASIC
Mahi