Monday, December 1, 2008

LOOPING IN STORED PROCEDURE [CURSOR IN SQL SERVER]

·

-- DECLARE VARIABLE AS INT
DECLARE @PRODUCTID AS INT

DECLARE SQLCURSOR CURSOR FOR
SELECT PRODUCTID FROM TBLPRODUCTMASTER
-- DECLARE CURSOR FOR SELECTED PRODUCTID
-- I HAVE ONE TABLE NAMED TBLPRODUCTMASTER AND I AM GETTING ALL PRODUCTID FROM THIS TABLE AND PRINT INDIVIDUAL PRODUCTID
OPEN SQLCURSOR
FETCH NEXT FROM SQLCURSOR INTO @PRODUCTID
WHILE(@@FETCH_STATUS=0)
BEGIN
PRINT @PRODUCTID
-- YOU CAN USE EACH PRODUCTID AND MAKE AN OPERATION ON THIS ID
FETCH NEXT FROM SQLCURSOR INTO @PRODUCTID
END
CLOSE SQLCURSOR
DEALLOCATE SQLCURSOR

0 comments: