creating a stored procedure

hi,
can we use table as an out parameter in sql stored procedure?
if so can any one help me out with an example.
thanks in advance
regards,
ThamaraiThis seem to be what you are locking for: http://www.sommarskog.se/share_data.html

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<thamarai.82@.gmail.com> wrote in message
news:1157544749.151831.33840@.h48g2000cwc.googlegroups.com...
> hi,
> can we use table as an out parameter in sql stored procedure?
> if so can any one help me out with an example.
> thanks in advance
> regards,
> Thamarai
>|||thamarai.82@.gmail.com wrote:
> hi,
> can we use table as an out parameter in sql stored procedure?
> if so can any one help me out with an example.
> thanks in advance
> regards,
> Thamarai
>
Look up "CREATE PROCEDURE" in Books Online... You'll find the answer is
no...
Tracy McKibben
MCDBA
http://www.realsqlguy.com|||Hi,
Can you please explain a bit more about your requirement? Incase if you want
to return a table as a result set then take a look into
URL from Tibors post.
Thanks
Hari
SQL Server MVP
<thamarai.82@.gmail.com> wrote in message
news:1157544749.151831.33840@.h48g2000cwc.googlegroups.com...
> hi,
> can we use table as an out parameter in sql stored procedure?
> if so can any one help me out with an example.
> thanks in advance
> regards,
> Thamarai
>|||The answer is No. But even if you could have a table datatype as an OUTPUT
parameter, what would you catch that with in the application? Does the
application provide a table datatype for a variable?
A Stored Procedure and provide a resultset, which the application can
capture as a table in a dataset. (Look up the use of the dataadapter
object.)
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
<thamarai.82@.gmail.com> wrote in message
news:1157544749.151831.33840@.h48g2000cwc.googlegroups.com...
> hi,
> can we use table as an out parameter in sql stored procedure?
> if so can any one help me out with an example.
> thanks in advance
> regards,
> Thamarai
>