How to get id one by one

Hi, Try this . (U tested)

DECLARE C CURSOR FOR

Select ID, industryid, industry

From Tablename

OPEN C

DECLARE @ID varchar(100), @IndustryID varchar(100), @Industry varchar(100)

FETCH NEXT FROM C INTO @ID , @IndustryID , @Industry

WHILE @@FETCH_STATUS = 0

BEGIN

PRINT N @ID;
PRINT N @IndustryID ;
PRINT N @Industry ;

FETCH NEXT FROM C INTO @ID , @IndustryID , @Industry

END

CLOSE C

DEALLOCATE C

0

give me some idea or code for this plz

0

Create one stored procdure.

In that stored procedure, writedown logic of creating cursor and perform operation row by row.

0

You can use SQL CURSOR for row by row operation.

0