Home Forums SQL Server 7,2000 T-SQL Find Affected Row Count from a Dynamic Query RE: Find Affected Row Count from a Dynamic Query

  • April 18, 2008 at 5:58 am

    #804265

    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.