Information générale
Forum:
Microsoft SQL Server
Versions des environnements
SQL Server:
SQL Server 2005
Hi
I'm performing the following stored procedure to essentially join 2 tables, with identical structures, to amalgamate the list of system/application messages into one dataset:
as
begin
set nocount on;
select * from dbo.SystemMessage union all select * from dbo.ApplicationMessage order by MessageID
end
I now want to pass a parameter into this stored procedure, @lnMessageID, and I'd like the statement to perform the join and THEN return the record from the joined results that matches @lnMessageID. @lnMessageID is always unique.
Regards
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