lsm123.sql

来自「java」· SQL 代码 · 共 36 行

exec sp_addlogin 'lsm9','123456'
exec sp_addlogin 'lsm8','123456'

exec sp_grantdbaccess 'lsm9'
exec sp_grantdbaccess 'lsm8'

create table lsm9.student
(id int,
name char(20),
class char(20),	
teacher_id int
)
insert into lsm9.student values(1,'zhangsan','CCNP',1)
insert into lsm9.student values(2,'lisi','CCNP',1)
insert into lsm9.student values(3,'wangwu','MCSE',2)
insert into lsm9.student values(4,'zhouliu','MCSE',2)

create table lsm8.teacher
(teacher_id int,
teacher_name char(20),
teacher_telnum int
)
insert into lsm8.teacher values (1,'steven',12345678)
insert into lsm8.teacher values (2,'shanght',87654321)

select * from lsm9.student
select * from lsm8.teacher


create view lsm
as 
select lsm9.student.id,lsm9.student.name,lsm9.student.class,
lsm8.teacher.teacher_name,lsm8.teacher.teacher_telnum
from lsm9.student inner join lsm8.teacher on
lsm9.student.teacher_id = lsm8.teacher.teacher_id