yii connect to mssql server 2012 stored procedure how to read return value

Yii 1.1 General Discussion
1

yii connect to mssql server 2012 stored procedure how to read return value ( my sql server database on remote location and connect to yii) and how to confirm data submit or not