You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I have many procedures with many parameters with default values. It would be nice to have ability to omit any default parameter, not only last.
I have 2 solutions:
description: I have many procedures with many parameters with default values. It would be nice to have ability to omit any default parameter, not only last.
I have 2 solutions:
SELECT * FROM PROC(1, , 5) or SELECT * FROM PROC(1, DEFAULT, 5)
2) Use named parameters (always in the end of list):
SELECT * FROM PROC(1, ?PARAM_C = 5) or SELECT * FROM PROC(?PARAM_A = 1, ?PARAM_C = 5)
=>
I have many procedures with many parameters with default values. It would be nice to have ability to omit any default parameter, not only last.
I have 2 solutions:
Submitted by: Alexander Tyutik (tut)
I have many procedures with many parameters with default values. It would be nice to have ability to omit any default parameter, not only last.
I have 2 solutions:
CREATE PROCEDURE PROC (
PARAM_A INTEGER,
PARAM_B INTEGER = 2,
PARAM_C INTEGER = 3
) ...
1) Use empty parameters or DEFAULT keyword:
SELECT * FROM PROC(1, , 5) or SELECT * FROM PROC(1, DEFAULT, 5)
2) Use named parameters (always in the end of list):
SELECT * FROM PROC(1, ?PARAM_C = 5) or SELECT * FROM PROC(?PARAM_A = 1, ?PARAM_C = 5)
The text was updated successfully, but these errors were encountered: