【文件属性】:
文件名称:sqlserverSET QUOTED_IDENTIFIER ON
文件大小:2KB
文件格式:SQL
更新时间:2011-10-01 05:34:47
store
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
ALTER PROCEDURE test @From varchar(100)="zhang.zhanling@itgemini.net" , @To varchar(100)="zhang.zhanling@itgemini.net" ,@eng varchar(1000)=" ", @Bcc varchar(500)="xu.ming;xie.yansheng", @Subject varchar(400)=" "
AS
declare @sum int
DECLARE T CURSOR FOR SELECT eng FROM event_tbl where status<>'关闭' and warn<>1 and datediff(hour,logtime,getdate())>4
DECLARE @NUM BIGINT
DECLARE @VARINT VARCHAR(50)
--一定要赋初值,不然在循环中@NUM的值不会改变
SELECT @NUM = 0
OPEN T
FETCH NEXT FROM T INTO @VARINT
WHILE @@FETCH_STATUS = 0
BEGIN
SELECT @NUM = @NUM+1