proceduredemo20.sql

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

/* 文件名称: ProcedureDemo20.sql */
DECLARE @RC int
DECLARE @Name nvarchar(20)
DECLARE @SaleYear int
SELECT @Name = N'赵飞燕'
SELECT @SaleYear = 1996
EXEC @RC = 北风贸易.dbo.EmployeeSaleByYear @Name, @SaleYear
DECLARE @PrnLine nvarchar(4000)
PRINT '存储过程: 北风贸易.dbo.EmployeeSaleByYear'
SELECT @PrnLine = '	返回值 = ' + CONVERT(nvarchar, @RC)
PRINT @PrnLine