[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