Is there any way i can get the row nos printed along with the records selected
For eg: Select SlNo, Names from Mytable
here Slno is not a Table column, Names is a table column in Mytable
The result recordset has to be like
where 1,2,3 should be autogenerated and can be used in a recordset as a column (Is there any function for this)
There's no default sql function that does this for you. However, the most common way to do this is to insert the rows into a temporary table that has an identity column. Then select the lot from the temp. table.