Is there any difference between the "set rowcount" inside and outside stored proc? Is there any login script for isql?
>> I am using isql
> So I'd issue a set rowcount xxx in isql before running the stored procs...
> Michael
>> >> Will it affect the performance if I add the first statement "set rowcount 500000" inside all my stored procedures?
>> > Don't know - but I would not do it. If you need to set the rowcount for *all* of your
>> > procs it would be better to set it on the connection itself from the client, possibly
>> > by defining a special version of the connect() call that does this for you.
>> > Michael
>> > --
>> > Michael Peppler -||- Data Migrations Inc.
>> > Int. Sybase User Group -||- http://www.veryComputer.com/
>> --
>> - Have several nice days...
>> - Opinions are mine and do not necessarily reflect those of the Corp.
>> http://www.veryComputer.com/
>> http://www.*port.com/~tangent/programming/winsock/
> --
> Michael Peppler -||- Data Migrations Inc.
> Int. Sybase User Group -||- http://www.veryComputer.com/
--
- Have several nice days...
- Opinions are mine and do not necessarily reflect those of the Corp.
http://www.veryComputer.com/
http://www.*port.com/~tangent/programming/winsock/