SELECT iD, ROW_NUMBER() OVER (ORDER BY iD) from myTable
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)