While <= ISNULL((SELECT COUNT(RowNo) FROM we set the variable value to the = Field1 FROM where RowNo = +1 Condition of Checking the No of records to be traverse Select A1, A2 from Your_Table Where Your_Condition All values are inserted into Your Table Variable. Create a Table Variable and Variable CounterĭECLARE TABLE(RowNo INT IDENTITY(1,1) NOT NULL PRIMARY KEY CLUSTERED, Field1 int, Field2 Int)ĭECLARE INT 'This variable is declare for Loop Instand of using this thing u can use the Table variable while loop which help lot compare to Cursor. īecause this code does not give the clear view of row by row operation.
I don't think that this row by row operation could really help some one.
0 kommentar(er)
