Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to insert a column in SQL Server
Message
De
16/04/2002 03:48:21
 
 
À
15/04/2002 15:19:08
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00644907
Message ID:
00645316
Vues:
13
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform