Samuele E. Locatelli
30 lines
681 B
Transact-SQL
30 lines
681 B
Transact-SQL
/***********************************************************************************
|
|
* FUNCTION rightDivision
|
|
*
|
|
* calcola la divisione altrimenti mostra errore -1 se dividendo/divisore < 0
|
|
*
|
|
***********************************************************************************/
|
|
CREATE FUNCTION rightDivision
|
|
(
|
|
@dividendo float,
|
|
@divisore float
|
|
)
|
|
RETURNS float
|
|
AS
|
|
BEGIN
|
|
|
|
declare @errore as int
|
|
declare @risultato as float
|
|
|
|
set @errore =0
|
|
|
|
set @errore = case when (isnull(@dividendo,0))<=0 then 1 end
|
|
|
|
set @errore = case when (isnull(@divisore,0)) <=0 then 1 end
|
|
|
|
set @risultato= case when (@errore=1) then -1 else @dividendo/@divisore end
|
|
|
|
RETURN @risultato
|
|
|
|
END
|