Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Insert values from all fields except for one
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Divers
Thread ID:
00762778
Message ID:
00762791
Vues:
16
oops the delimiters i used removed the code in between them on the last message

If you are trying to keep the identity column in the new table in tact then you can't bulk copy but you can do an insert select. ex.

INSERT INTO [newdatabase]..[newtable] ([AllColumnsExceptIdentity]) FROM (SELECT [AllColumnsExceptIdentity] FROM [olddatabase]..[oldtable])
Thanx,
Bill Elvin
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform