create
view
view1
as
select
from
table1
当你select
from
view1的时候其实执行的是select
from
table1在管理工具中视图上右击,选择设计可以看到
或者运行以下sql语句:
select
text
from
syscomments
s1
join
sysobjects
s2
on
s1id=s2id
where
name='视图名称'
当然前提条件是视图没有被加密
我也是网上搜的,你可以试试create view v_infomation(请假申请编号,员工姓名,提交时间,请假原因,状态,拒绝原因)
as select QJ_BIAO请假申请编号,employee员工姓名,QJ_BIAO提交时间,QJ_BIAO请假原因,QJ_BIAO状态,QJ_BIAO拒绝申请的理由
from QJ_BIAO,employee
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)