RE: Find Affected Row Count from a Dynamic Query – SQLServerCentral

SSChampion

Points: 13623

April 18, 2008 at 5:58 am

This might be simpler...

Replace this...

EXEC @rowcount = sp_executesql @strSql

with this...

EXEC sp_executesql @strSql

set @rowcount = @@RowCount

Ryan Randall

Solutions are easy. Understanding the problem, now, that's the hard part.