Resolved: Output parameters
What's the purpose of saving output parameters in the database. In which case it will be useful? Kindly explain.
Thanks in advance.
2 answers ( 2 marked as helpful)
Thanks for reaching out.
The output parameters in stored procedures are used to return some value or values. A stored procedure can have any number of output parameters. The simple logic is this — if you want to return 1 value then use 1 output parameter, for returning 5 values use 5 output parameters and so on.
Hope this helps.
Thank you so much for the clarification.
Submit an answer
I wrote this below code , but the output contained both M and F. I did not got the logic
I HAD GIVEN OUTPUT AS SALARY_P BUT WHEN I CALLED THE PROCEDURE IT ALSO ASKING FOR IN OF THE OUT
Resolved: Queries with LIKE('Mar%') and LIKE('Mar_') are returning the output with 1000 rows each