proceduredemo9.sql

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

/* 文件名称: 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