Skip to content

Settings and activity

2 results found

  1. 51 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    An error occurred while saving the comment
    Jeff M commented  · 

    Or, more like what you asked for, you can PRINT the ROWCOUNT:

    UPDATE table SET field = 0 WHERE field = 123456
    PRINT convert(varchar(30),@@ROWCOUNT) + ' records affected'

    An error occurred while saving the comment
    Jeff M commented  · 

    Found a temp solution. Use the OUTPUT clause. Link: http://programming4.us/Database/3720.aspx

    Jeff M supported this idea  · 
  2. 1,276 votes
    Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    You have left! (?) (thinking…)
    How important is this to you?

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)
    Jeff M supported this idea  ·