sequence credit cards using ROW_NUMBER?
Execute the following
script in Query Editor to create a sequence named RowNo as an
output column for listing credit card ids for the Sales Department:
SELECT ROW_NUMBER() OVER (ORDER BY CreditCardID)
|The World Leader
in SQL Server Training