游标

--break :终止循环
DECLARE youbiao 
 CURSOR  for
 SELECT Id,CreatedOn FROM dbo.SiteLetter
 
DECLARE @strsql NVARCHAR(max)
OPEN youbiao
DECLARE @id INT
DECLARE @CreatedOn DATETIME
FETCH NEXT FROM youbiao INTO @id,@CreatedOn 
 
WHILE @@FETCH_STATUS=0
BEGIN
----for里面每一条记录的操作
--PRINT @id
--PRINT @CreatedOn
IF @id=100017
BEGIN
SET @strsql=@id
BREAK
END

----for里面每一条记录的操作
 
FETCH NEXT FROM youbiao INTO @id,@CreatedOn 
 
END
 
PRINT @strsql 
PRINT 1

CLOSE youbiao
DEALLOCATE youbiao

--SELECT * FROM  dbo.Siteletter

 

 

--break :终止循环
DECLARE youbiao 
 CURSOR  for
 SELECT Id,CreatedOn FROM dbo.SiteLetter
 
DECLARE @strsql NVARCHAR(max)
OPEN youbiao
DECLARE @id INT
DECLARE @CreatedOn DATETIME
FETCH NEXT FROM youbiao INTO @id,@CreatedOn 
 
WHILE @@FETCH_STATUS=0
BEGIN
----for里面每一条记录的操作
--PRINT @id
--PRINT @CreatedOn
IF @id=100017
BEGIN
SET @strsql=@id
RETURN
END

----for里面每一条记录的操作
 
FETCH NEXT FROM youbiao INTO @id,@CreatedOn 
 
END
 
PRINT @strsql 


CLOSE youbiao
DEALLOCATE youbiao

--SELECT * FROM  dbo.Siteletter

-----------当return的时候没关闭游标会直接报错，所以在返回的时候一定要CLOSE youbiaoDEALLOCATE youbiao-----------

 

 BEGIN TRANSACTION--break :终止循环
DECLARE youbiao 
 CURSOR  for
 SELECT Id,CreatedOn FROM dbo.SiteLetter
 

declare @errorSum int  
DECLARE @strsql NVARCHAR(max)
OPEN youbiao
DECLARE @id INT
DECLARE @CreatedOn DATETIME
FETCH NEXT FROM youbiao INTO @id,@CreatedOn 
 
WHILE @@FETCH_STATUS=0
BEGIN
----for里面每一条记录的操作
--PRINT @id
--PRINT @CreatedOn
IF @id=100017
BEGIN
--SELECT * FROM  dbo.Siteletter WHERE Id=100018 

UPDATE dbo.Siteletter SET  CreatedOn='1987-8-6' WHERE Id=100018
---UPDATE dbo.Siteletter SET  CreatedOn='kk' WHERE Id=100017
CLOSE youbiao
DEALLOCATE youbiao
RETURN
END

----for里面每一条记录的操作
 
FETCH NEXT FROM youbiao INTO @id,@CreatedOn 
 
END 

CLOSE youbiao
DEALLOCATE youbiao   
   

   
rollback TRANSACTION
PRINT '事务回滚'
 

  
 SELECT * FROM dbo.Siteletter
 
 尊敬的会员，<BR>您的订单：60221 内含有电子卡类礼品。<BR><BR>请<a href=/modules/prize/myevoucher.asp?order_id=60221> [点击此处] </a>查看电子礼券的卡号和充值码。<BR>（注：当您点击查看礼券信息后，系统将默认为您在该订单内兑换的电子礼券礼品已被您签收）