--游標(biāo)

declare @userID uniqueidentifier--userid

declare y_curr cursor for

select top 2 userID from Hope_Users_db.dbo.u_Users order by addTime desc



open y_curr --打開游標(biāo)

fetch next from y_curr into @userID ----開始循環(huán)游標(biāo)變量

while(@@fetch_status=0)---返回被FETCH  語(yǔ)句執(zhí)行的最后游標(biāo)的狀態(tài)，而不是任何當(dāng)前被連接打開的游標(biāo)的狀態(tài)。

begin

	   if exists (select * from Q_enterprise where userID = @userID)

		  begin

		     print @userID

		  end

		else

		  begin

			   print @userID

			   insert into Q_enterprise

			   select distinct u.userID, u.userType,u.SyncCharityId as CharityId,u.userTrueName,u.userLogo,0 as donationAmount,e.enterpriseContactMobile,

			   e.enterprisePurpose,0 as enterpriseLongitude,0 as enterpriseLatitude,'' as Infoproportion,0 as sharesum,0 as praisesum,

			   0 as Donationsum,0 as Farvritessum,0 as Donationsum30,u.addTime,'' as updatetime

			   from Hope_Users_db.dbo.u_Users u

			   inner join Hope_Donation_DB.dbo.d_Donation d

			   on u.userID=d.userID

			   inner join Hope_Users_db.dbo.u_Enterprise e

			   on u.userID = e.userID

			   where u.userID=@userID

		  end

      fetch next from y_curr into @userID --開始循環(huán)游標(biāo)變量

end

close y_curr--關(guān)閉游標(biāo)

deallocate y_curr --釋放游標(biāo)

go