[thelist] updating two text fields in MSSQL

mattias at thorslund.us mattias at thorslund.us
Mon Mar 13 19:56:12 CST 2006


Quoting "Canfield, Joel" <JCanfield at PacAdvantage.org>:

>> (hopefully you only need to update one
>> row at the time as well)
>
> Nope; ten to fifteen thousand.
> --

Ouch...  Hopefully it's not a performance sensitive routine but some kind of
maintenance script?

Cursors can do this, and probably even UDFs, but neither will be *fast*, I'm
afraid.

Have fun.

Mattias




More information about the thelist mailing list