How to generate increasing record number automatically in sql

When you want to do line/record numbering automatically on your query, simply use 'ROW_NUMBER()' . example:

SELECT ROW_NUMBER() OVER (ORDER BY [field1] asc/desc) as Row_Number, [Otherfields]
FROM [database].[dbo].[table]

that should do it...