Einfache Stored Proc

[shmia]

Etwa so (ungetestet):

SQL-Code:

CREATE PROCEDURE Test (@WKN VARCHAR(6), @ISIN VARCHAR(12), @outparam VARCHAR(12) OUTPUT) 
As 
   if @WKN is NULL 
       Select @outparam = WKN From Tabelle Where ISIN = @ISIN 
   else 
       Select @outparam = ISIN From Tabelle Where WKN = @WKN 
GO