SQL Server index of each line

select row_number() over (order by (select 1)), * from dbo.Table as t
To display in first column index of each row.

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.