视图.sql

简单的sql语句 数据与汇总。 高手多多指点。

create view [employee view]
with encryption
as
select lastname,firstname
from employees
go

select * from [employee view]
go

create view ordersubtotalview(orderid,subtotal) 
as 
select od.orderid,sum(convert(money,(unitprice*quantity*(1-discount)))
from [order details]  as od
group by od.orderid
go

alter view [employee view]
as
select * from orders
go

drop view [employee view]
go

exec sp_helptext [employee view]
go

exec sp_depends [employee view]
go