Traverse a MSSQL table without using CURSOR

To traverse a table without cursor, you only need to add an additional field in the table with null value. Here is the code for traversing a table.