Run Code
|
API
|
Code Wall
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
test1
create table Student( Sno varchar(20) not null primary key, Sname varchar(20) not null , Ssex varchar(20) not null, Sbirthday datetime , Class varchar(20) ) create table Teacher( Tno varchar(20) not null primary key, Tname varchar(20) not null , Tsex varchar(20) not null, Tbirthday datetime, Prof varchar(20) , Depart varchar(20) not null ) create table Class ( Cno varchar(20) not null primary key, Cname varchar(20) not null, Tno varchar(20) not null, constraint for_key Foreign key(Tno) references Teacher(Tno) )
run
|
edit
|
history
|
help
0
Duplicate Records
Tarea1
MLK Date
add loopback linked server
Trabalho.Agrecação
add-empty-rows-after-certain-records-in-a-table
mywall
Demo
Libros
Microsoft SQL Server T-SQL in 10 mn ~ Lesson 13 Subqueries vers.#3