Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Insert Row Id's
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Title:
Re: Insert Row Id's
Miscellaneous
Thread ID:
01370506
Message ID:
01372153
Views:
25
>I have imported an Excel file into a SQL table. There is nothing unique in the data, so I want to add an Id column and populate it with 1 to the record count.
>
>How do I do this in SQL 2005?

Use a GUID instead of an int.
__Stephen Russell
>>
"Simplicity is the ultimate sophistication."

Leonardo da Vinci

>> My old crummy site.
Previous
Reply
Map
View

Click here to load this message in the networking platform