游标 循环插入值

 DECLARE @AccessRightFK VARCHAR(500)
 DECLARE @UserGroupFK uniqueidentifier

 DECLARE UserGroup_Cursor CURSOR FOR
 
 SELECT AccessRightFK,UserGroupFK
 FROM sec.UserGroup_AccessRight ugar WHERE ugar.AccessRightFK = 'Client/Module/QuotationTemplate'


 
 OPEN UserGroup_Cursor
 
 FETCH NEXT FROM UserGroup_Cursor 
 INTO @AccessRightFK, @UserGroupFK
 
 WHILE @@FETCH_STATUS = 0
 BEGIN     
    DECLARE @AccessRight nvarchar(100)
    DECLARE @RecordCount int = 0

     -- Find if exist
    SELECT @RecordCount=COUNT(1)
    FROM sec.UserGroup_AccessRight ugar
    WHERE ugar.UserGroupFK=@UserGroupFK AND ugar.AccessRightFK = 'Client/Module/CaseFolder/QuotationView'

    -- Find AccessRight
    SELECT @AccessRight = ugar.AccessRight
    FROM sec.UserGroup_AccessRight ugar
    WHERE ugar.UserGroupFK=@UserGroupFK AND ugar.AccessRightFK = @AccessRightFK

    -- Insert if not exist
     IF @RecordCount = 0
    BEGIN
        INSERT INTO SEC.UserGroup_AccessRight
        (
            AccessRightFK,
            UserGroupFK,
            AccessRight
        )
        VALUES
        (
            'Client/Module/CaseFolder/QuotationView', -- AccessRightFK - varchar
            @UserGroupFK, -- UserGroupFK - uniqueidentifier
            @AccessRight -- AccessRight - varchar
        )
    END
     
      FETCH NEXT FROM UserGroup_Cursor 
    INTO @AccessRightFK, @UserGroupFK
 END 
 
 
 CLOSE UserGroup_Cursor;
 DEALLOCATE UserGroup_Cursor;