EXEMPLO_1212310
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
GETPARAMPERCENT
Parameters
Name
Type
Mode
@CODCOLIGADA
int
IN
@CODEXAME
int
IN
@CODMETODO
int
IN
@CODPARAMETRO
int
IN
Definition
CREATE FUNCTION GETPARAMPERCENT(@CODCOLIGADA INT, @CODEXAME INT, @CODMETODO INT, @CODPARAMETRO INT) RETURNS INT AS BEGIN DECLARE @PARAMPERCENT INT; DECLARE @PARAM INT; SELECT @PARAMPERCENT = PERCPARAMETRO, @PARAM = CODPARAMETRO FROM SZLABPARAMEXAMES WHERE CODCOLIGADA = @CODCOLIGADA AND CODEXAME = @CODEXAME AND CODMETODO = @CODMETODO AND CODPARAMETRO = @CODPARAMETRO; IF (@PARAMPERCENT IS NOT NULL) SET @PARAM = DBO.GETPARAMPERCENT(@CODCOLIGADA, @CODEXAME, @CODMETODO, @PARAMPERCENT); RETURN @PARAM; END