> Is There Any Way of returning the complete recordset instead of one or
> two columns
>
> Because Have to return the rows from the table which is having More
> than 70 Columns and it is not feasible to Returns 70 Variables from SP

No, you have to create 70 output variables.

You might want to look into GUI tools to aid you in this.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com