Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Change data type on all char(36) columns in db
Message
De
04/09/2013 23:15:57
 
 
À
04/09/2013 23:10:25
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Syntaxe SQL
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Web
Divers
Thread ID:
01582234
Message ID:
01582248
Vues:
29
Yeah, sorry I didn't see that before. To the best of my awareness you need a separate ALTER TABLE statement for each column.

I vaguely recall trying different combinations of syntax before, to avoid separate ALTER TABLE statements, and I was never able to get it work. I think at one point Naomi and I were talking about this, and I don't remember if either of us ever came up with a solution (other than separate ALTER TABLE statements)

I think you can do multiple ADD statements with just one ALTER TABLE, but I don't think you can modify multiple columns with just one ALTER TABLE.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform