SQL Server 高级操作

视图

创建视图

　　　　create view student1(name,age,idd,aname) as select b.name,b.age,b.idd,a.name from student b,course a where b.idd=a.id　　　　create view student1(name,age,idd,aname)