proceduredemo8.sql

T-SQL示例大全

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

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.EmployeeByIdNameAddress') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.EmployeeByIdNameAddress
GO

CREATE PROCEDURE dbo.EmployeeByIdNameAddress
@id nvarchar(10) = N'[A-M]%',
@name nvarchar(10) = N'许%',
@address nvarchar(10) = N'%北京市%'
AS
SELECT * FROM 飞狐工作室
   WHERE 身份证号码 LIKE @id AND
                  姓名 LIKE @name AND
                  家庭地址 LIKE @address
GO