| How to generate a sequence in SQL Server 2005? |
|
Execute the following
script in Query Editor to create a sequence of 100 integers:
use AdventureWorks
select top 100 row_number()
over (order by object_id asc)
from sys.objects
|
| SQLUSA - The Best SQL Server
2005 Training in the World |
|
