Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Versions des environnements
SQL Server:
SQL Server 2000
>I have a feeling a lot of your design decisions were made around the limitation of VFP that you couldn't add/remove fields without exclusive access to the table. In SQL Server that limitation is removed and that should simplify some of your rewrite decisions.
>
>I'm assuming in your app you used generic char fields and then in your metadata tracked what type of data was actually being stored (numeric, date, etc.). In SQL server, because you can add fields on the fly, the fields types can actually match the data that is being stored.
That's a good point. For some reason I am still leery of issuing ALTER TABLE on the fly. If nothing else it's going to be time consuming for a table of any size.
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement