Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
XML as a field
Message
De
11/07/2002 13:56:32
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Titre:
Divers
Thread ID:
00677659
Message ID:
00677661
Vues:
20
>I was just in a meeting where the database designers are adding flexibility by doing the following:
>Any new fields that is added to a column, will go into the last field of a table that is an XML string. This String will allow for multiple fields to be added dynamically.
>Do you think this is a good idea?
>What are the drawbacks?? Can you search on this field in the string?

By column, do you mean table?

If this regards to gathering data from various sources/types into one single field, than you will end up with less flexibility for your tags, manipulations, etc. But, again, maybe you have some good advantages for your requirements to do it like that.
Michel Fournier
Level Extreme Inc.
Designer, architect, owner of the Level Extreme Platform
Subscribe to the site at https://www.levelextreme.com/Home/DataEntry?Activator=55&NoStore=303
Subscription benefits https://www.levelextreme.com/Home/ViewPage?Activator=7&ID=52
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform