游标的使用

DECLARE @UserID1 uniqueidentifier
  DECLARE MyCursor CURSOR FOR
  --取出游标中的数据集
  select u.UserID
  from lc_userinfo u left join admin_group g on u.groupid=g.groupid
  where g.areaid= @AreaID or @AreaID='230100'
  OPEN MyCursor
  FETCH NEXT FROM MyCursor INTO @UserID1
  
  WHILE(@@FETCH_STATUS=0)
   BEGIN  

    INSERT INTO [PublishiInfoanduserinfo](
    [PUID],[UserID],[PublisID],[Inactive],[AreaID]
    )VALUES(
    NewID(),@UserID1,@PublisID,'0',@AreaID
    )
  FETCH NEXT FROM MyCursor INTO @UserID1
  END
  CLOSE MyCursor--关闭游标
  DEALLOCATE MyCursor--释放游标