create view2.sql

来自「本程序中即有讲义」· SQL 代码 · 共 12 行

USE pubs 
go
CREATE VIEW CAonly AS 
SELECT au_lname, au_fname, city, state FROM authors 
WHERE state = 'CA'
 WITH CHECK OPTION
go
select * from caonly
select * from caonly where city like '[sv]%'

--select * from caonly where city = '[sv]%'