programmatically switching off (x row(s) affected) in query analyser results pane

  • hey guys,

    just a quicky, i can't remember for the life of me how to programmatically turn off the (x row(s) affected) result returned to the query analyser results pane in T-SQL.  anyone rememeber please?

    many thanks,

    lloyd

  • Use 'set nocount', eg

    set nocount on

    select etc

    ...

    set nocount off

    Regards

    Phil

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

  • thats the one,

    thanks phil

Viewing 3 posts - 1 through 2 (of 2 total)

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