
June 11th, 2004, 09:25 PM
|
 |
Banned ;)
|
|
Join Date: Nov 2001
Location: Woodland Hills, Los Angeles County, California, USA
|
|
|
Rules of thumb:
1. If the stored procedure merely updates/inserts/deletes tables, but does not return rows, use Execute (though I think Open would also work)
2. If the stored procedure returns a result set, always use Open. You cannot use Execute and expect to iterate through the result set.
__________________
Up the Irons
What Would Jimi Do? Smash amps. Burn guitar. Take the groupies home.
"Death Before Dishonour, my Friends!!" - Bruce D ickinson, Iron Maiden Aug 20, 2005 @ OzzFest
Down with Sharon Osbourne
|