Skip to content
  • There are no suggestions because the search field is empty.

T-SQL Script: Generate sequential numbers (without identity)

T-SQL Script: Generate sequential numbers (without identity)

SELECT ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) AS SeqNum, *
FROM MyTable;