Passing a rowset to a stored procedure?

[Peter Strøiman]

Hi.

I have a situation where I would like to check to see if a number of records
have been updated in a table.
My application store the primary key and the timestamp values internally,
and could for example pick out 5 of these and would then need to check if
the original records have been updated.

I could of course easily create a stored procedure that takes the primary
key as parameter and then makes a single select and returns the value. But I
would have to call that 5 times meaning 5 times the overhead.

Can I create a stored procedure that accepts a rowset, and then pass the
rowset with 5 records as a parameter to the stored procedure?

And if I can create such a stored procedure, how do I build the rowset in my
code and pass it to the stored procedure?

Thanks in advance,
Pete

 

[William Ryan eMVP]

Peter:

If i understand the problem, I think you could just create an array and then
pass that to your stored proc. The proc could read through the values and do
whatever from there. There's no 'rowset' parameter per se, but you can
easily work around it http://www.knowdotnet.com/articles/temptables.html

HTH,

Bill