|
Posted by =?Utf-8?B?am9zaGVmIHNhdm9uYQ== on August 11, 2005, 6:16 pm
If you were Registered and logged in, you could reply and use other advanced thread options
pic
"bajopalabra" wrote:
> how can i call an stored proc
> passing an array as parameter ?
>
> how can i do something like this ?...
>
> create procedure my_sp
> @array ...
> as
> select *
> from table
> where field IN ( @array )
>
> i was thinking in creating a table "tmp"
> and fill it with the parameters....
> begin tran
> insert into tmp values ( aaa )
> insert into tmp values ( ... )
> insert into tmp values ( zzz )
> exec my_sp
> commit tran
>
> ( it's cursi, i know.... )
>
> --
> atte, Hernán
>
>
>
| 
XML site map