FDiri
12/3/2015 - 11:09 AM

cursor structure

cursor structure

DECLARE @fileUrl VARCHAR(500)
DECLARE @productId INT 

DECLARE crsr CURSOR FOR
SELECT ID,FileUrl FROM dbo.Product WHERE ISNULL(FileUrl,'') <>''
OPEN crsr
FETCH NEXT FROM crsr INTO @productId,@fileUrl

WHILE @@FETCH_STATUS =0
	BEGIN
	UPDATE	dbo.ProductDescription SET FileUrl=@fileUrl WHERE ProductID=@productId AND LanguageID=1
		
	FETCH NEXT FROM crsr INTO @productId,@fileUrl
	END
CLOSE crsr

DEALLOCATE crsr