0005 sql视图

use xiketangtest

go

--删除视图

if exists (select * from sysobjects where name ='view_mytest')

drop view view_mytest

go

--创建视图

create view view_mytest

as  

select studentname ,studentid from students

inner join scorelist on students.studentid=scorelist.studentid

go

select * from view_mytest

--视图只是查询，不能有：1，order by ，必须有top

--2，into关键字

--3，引用临时表或变量