EXEC SP ‘procAlertGetOut’ WITH 2 params return

swiftinitpvtltd · Post by **swiftinitpvtltd** » Fri Apr 23, 2021 5:42 am

EXEC SP ‘procAlertGetOut’ WITH
‘@alerID’=SPParam.AlertId,’@alertName’=SPParam.AlertName OUT

What if I have to return 2 params from stored proc. How do I write that?

BLOMASKY · Post by **BLOMASKY** » Fri Apr 23, 2021 8:06 pm

I believe you can have many input and output params. Just put an out after each one. Did you try that?

The only limitation is with the EXEC_SPF. It can only have 1 OUT

Bruce

swiftinitpvtltd · Post by **swiftinitpvtltd** » Sat Apr 24, 2021 2:31 am

That worked! Thank you.

Aware IM User Forums

EXEC SP ‘procAlertGetOut’ WITH 2 params return

EXEC SP ‘procAlertGetOut’ WITH 2 params return

Re: EXEC SP ‘procAlertGetOut’ WITH 2 params return

Re: EXEC SP ‘procAlertGetOut’ WITH 2 params return