record will store in last row u can count the rows and get the number of row rows.count method
On 9/5/09, Yonggang, Meng <[email protected]> wrote: > > > ROW_NUMBER() OVER(ORDER BY [column name]) is what you want. > > On Sep 4, 9:12 pm, san <[email protected]> wrote: > > How can i get the row number in which record is stored in sql server. > > > > Example: suppose if record is stored in fifth row i want output as 5. > > > > Thanks! >
