SELECT ROW_NUMBER() OVER (ORDER BY Id) AS RowNum,* FROM myTable
SELECT ROW_NUMBER() OVER (ORDER BY ColumnName1) As SrNo, ColumnName1, ColumnName2,ColumnName3 FROM TableName
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)