辅助

sp_help 图书表

sp_help 借阅表

sp_help 读者表

select * from 读者表

select * from 借阅表

select * from 图书表



delete 图书表
    where 图书号='P913.2/530'

update 图书表
    set  单价=40 ,出版社='电子工业出版社'
    where 图书号='TP316/ZW6'

insert 借阅表
    values('081688','TP311.13/CM3',getdate(),null)
insert 借阅表
    values('081688','TP311.132/ZG1',getdate(),null)
insert 借阅表
    values('081690','TP311.132/ZG1',getdate(),null)
insert 借阅表
    values('081690','TP913.2/530',getdate(),null)

update 图书表
    set 出版社 ='电子工业出版社'
    where 作者='苗雪兰'

insert 借阅表
    values('081688','TP311.13/CM3',getdate(),null)

drop table #tmp2,#tmp3


update 读者表
    set 姓名='王平' ,办公电话='68321789'
    where 姓名='王平'

insert 图书表
    values('TP913.2/531','java基础','王团结','科学出版社',100)

update Course
    set Course_Name='高数'
    where Course_No='20191'

select * from student

select * from SelectCourse

select * from Course

select * from Student

update Course
    set Course_Credits=4
    where Course_No='20181'or Course_No='20182'

select *
from view_course_credits
go

select * from view_Studentinfo
go

sp_help view_Studentinfo

sp_helptext view_Studentinfo

sp_depends view_Studentinfo

sp_helptext view_

drop view view_Avg

select * from view_Is_Student_b

select * from view_Is_Student_Birth

select * from view_Avg

sp_helptext selectcourse