proceduredemo9.sql

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

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

EXECUTE EmployeeByIdNameAddress
GO

EXECUTE EmployeeByIdNameAddress N'[^ALM]%',N'_正_',N'%天津市%'
GO

EXECUTE EmployeeByIdNameAddress N'[A-B]%'
GO

EXECUTE EmployeeByIdNameAddress N'[A-M]%',N'%',N'%'
GO

EXECUTE EmployeeByIdNameAddress N'%',N'%',N'%中山路%'
GO

-- 返回所有数据记录
EXECUTE EmployeeByIdNameAddress N'%',N'%',N'%'
GO