I have a very simple set up
I am connecting to a MS SQL db using SQSH statement from a shell script
In this sqsh connection i am trying to execute a stored proc
However I want to capture the value returned by the stored proc.
I haven't really come across anything useful so far which would help me solve the problem.
Code snippet is something like below
sqsh -Uuser -Ppasswd -Sserver <<EOF
use Database
go
exec stored_prod
go
EOF