viewdemo10.sql

来自「T-SQL示例大全」· SQL 代码 · 共 25 行

/*
文件名称: ViewDemo10.sql
*/
USE 北风贸易
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO

ALTER VIEW vw_北区客户
AS
SELECT * FROM 客户 
    WHERE 城市 IN ('北京市','密云','青岛','大连市','上海市')

GO

SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO