Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to insert a column in SQL Server
Message
From
16/04/2002 03:48:21
 
 
To
15/04/2002 15:19:08
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
00644907
Message ID:
00645316
Views:
12
This message has been marked as a message which has helped to the initial question of the thread.
Alejandro,

As pointed out by Sergey in another message, this is not a trivial task on existing tables. I don't know how difficult it would be to adjust the upsize wizard to modify the method that creates the SPROC you mentioned. But if you change the INSERT INTO xxx VALUES() line to INSERT INTO xxx (col2, col3, coln) VALUES(v1, v2, vn) it should work and there shouldn't be any performance penalty.

HTH
>Thank you Daniel. I have modified the upsize wizard and currently use its classes for upsizing under program control.
>
>Problem is that I want to make the first column the identity column and PK. However, in order to speed sending the data the wizard creates a SPROC that uses INSERT INTO xxx VALUES( ) without naming the fields. This means that a value gets sent to the first field, which gives an error.
>
>So I now am looking for a command to convert the first column into the identity column after the export is already made. If you know how I'd appreciate it.
>
>Alex
Daniel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform