1 if OBJECT_ID(Sales.USACusts) is not null 2 drop view Sales.USACusts; 3 go 4 5 create view Sales.USACusts 6 as 7 select custid,company ...
1 if OBJECT_ID('Sales.USACusts') is not null 2 drop view Sales.USACusts; 3 go 4 5 create view Sales.USACusts 6 as 7 select custid,companyname,contactname,contacttitle,address,city,region,postalcode,country,phone,fax 8 from Sales.Customers 9 where country=N'USA';10 go
原标题:视图的创建、修改
关键词:
*特别声明:以上内容来自于网络收集,著作权属原作者所有,如有侵权,请联系我们:
admin#shaoqun.com
(#换成@)。