Post reply

Number of Rows

  • January 25, 2013 at 12:07 pm

    #1581180

    sorry to say, but your question is bogus. I just ran it on my SQL 2008 instance and received no row(s) effected message at all.

    default settings. Doesn't even matter if set nocount is off/on. And I tested it with SQL 2012 too. Same results.

    The one thing that might be different is I'm using SSMS 2012.

    Dennis Parks
    MCSE, MCDBA, MCSD, MCAD, MCTS

  • January 25, 2013 at 2:30 pm

    #1581218

    +0

    Don't like these kind a questions.

  • July 24, 2015 at 4:03 pm

    #1814926

    I think inside the begin trans...commit, it all are counted as a single transaction. Hence 1 row is affected.

    Thanks.

Viewing 3 posts - 46 through 48 (of 48 total)

You must be logged in to reply to this topic. Login to reply