Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Record ID generator question
Message
De
21/09/2002 14:40:57
 
 
À
20/09/2002 17:43:25
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Conception bases de données
Divers
Thread ID:
00605839
Message ID:
00703091
Vues:
29
>>>> In other words, so that a new record is created in the keys table if a call is made with the name of a table that is not yet in the table.
>>
>>Why would you want this? If you or another develop supply the wrong tablename, maybe spelled incorrectly, you would get another row and might not realize the problem that has been introduced.
>
>Yes, misspelling is a problem. On the other hand, it would simplify updating a client site as product evolves and new tables are added.

True, but you could do the same thing explicitly with a script when the application was deployed.

To answer your original question, if the variable's value was NULL, the requested table probably didn't exist and you could insert the row at that point.

But I still don't think it's a good idea.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform