-- 方法2：使用表变量批量发送买励

-- 声明表变量

 DECLARE ftemp TABLE

 (

 character_no NVARCHAR(50),

 character_name NVARCHAR(50)

  );

-- 将源表中的数据插入到表变量中0 {

 INSERT INTO @temp(character_no,character_name )  

 SELECT character_no ,character_name FROM user_character where character_name not like '%dev%' ;

-- 声明变量

 DECLARE @character_no AS NVARCHAR(50);

 DECLARE @character_name AS NVARCHAR(50);

 WHILE EXISTS(SELECT character_no FROM @temp)

 BEGIN

-- 也可以使用top 1

 SET RONCOUNT 1

 SELECT  @character_no= character_no ,@character_name= character_name FROM @temp  ;

-- 邮件

 EXEC character.dbo.SP_POST_SEND_OP @character_no,'GM',1,'请尽快领取','GM','60196',0,0

 SET ROWCOUNT 0

 DELETE FROM @temp WHERE character_no= @character_no;

END