viewdemo9.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

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

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.vw_北区客户') and OBJECTPROPERTY(id, N'IsView') = 1)
drop view dbo.vw_北区客户
GO

CREATE VIEW vw_北区客户
AS
SELECT * FROM 客户 
    WHERE 城市 IN ('北京市','密云')
GO