Information générale
Forum:
Microsoft SQL Server
Catégorie:
Stored procedures, Triggers, UDFs
Hi,
(1)
I have two tables,
one contains current records,
2nd one contains history records.
Selection will be: if records cannot be found in current, then go to find in history.
Question: What's the best method in this case? I can only think that use IF..ELSE statement and dup whole set SELECT statements, it's quite dummy.....
(2)
I pass one parameter into stored prod,
Question: Can I accept that, if the passing parameter is " " blank, then select all records, else, select the specified record?
Is it the only method using IF..ELSE statement and dup whole set SELECT statement??
What can I do???
Pls HELP!!
Best Regards,
Eva ^.^
Suivant
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