SQL游标循环处理插入、修改语句

最新推荐文章于 2024-11-23 22:57:02 发布

xiaokui604

最新推荐文章于 2024-11-23 22:57:02 发布

阅读量2.7k

点赞数

分类专栏：数据库 ASP.NET 文章标签： sql action insert delete

本文链接：https://blog.csdn.net/xiaokui604/article/details/7449680

版权

ASP.NET 同时被 2 个专栏收录

27 篇文章 0 订阅

订阅专栏

数据库

2 篇文章 0 订阅

订阅专栏

DECLARE @Action nvarchar(50)
DECLARE @Remark nvarchar(100)
DECLARE myCusor CURSOR FOR
SELECT [Action],Remark FROM UserVisit WHERE 
[Action] LIKE '获取验证码%'
AND UserName='' AND Remark<>''
OPEN myCusor
FETCH NEXT FROM myCusor INTO @Action,@Remark
    WHILE @@FETCH_STATUS = 0
    BEGIN
    	IF (SELECT COUNT(1) FROM CaiCaiUserImport WHERE EncryptedMobile=@Remark) <>''
    	BEGIN
    		DELETE CaiCaiUserImport WHERE EncryptedMobile=@Remark
    	END
    	INSERT INTO CaiCaiUserImport
		(
			Notes,
			EncryptedMobile
		)
		VALUES
		(
			@Action,
			@Remark
		)
        print (@Action+ '  '  +@Remark)
        FETCH NEXT FROM myCusor INTO @Action,@Remark
    END
    CLOSE myCusor
    DEALLOCATE myCusor