Home Forums SQL Server 2005 SQL Server 2005 General Discussion Reusing SQLCommand RE: Reusing SQLCommand
Ninja's_RGR'us
SSC Guru
Points: 294069
More actions
September 24, 2007 at 3:13 pm
#735796
You can also use sp_execsql for this.
You can also consider the option to run a single query that will update all rows in a single pass (assuming it's possible).