WHERE A AND B
FUNCTION [dbo].[fonc] ( @ID_UO_LIST VARCHAR(MAX), @SEPARATEUR CHAR(1) ) RETURNS TABLE AS SELECT * FROM MaTable As ta WHERE IF
FUNCTION [dbo].[fonc] ( @ID_UO_LIST VARCHAR(MAX), @SEPARATEUR CHAR(1) ) RETURNS TABLE AS SELECT * FROM MaTable As ta WHERE IF (CHARINDEX(@ID_UO_LIST,',') > 0 ta.val = @ID_UO_LIST ELSE ta.val IN (select * from FN_SPLIT_TO_TABLE( @ID_UO_LIST,@SEPARATEUR))
if CHARINDEX(@SEPARATEUR,@ID_UO_LIST) = 0 return @NUM_VAR + '=' + @ID_UO_LIST else return @NUM_VAR + 'IN (' + @ID_UO_LIST + ')' END
return @NUM_VAR + 'IN (' + @ID_UO_LIST + ')'
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question