viewdemo10.sql

来自「100多个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