Post reply

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

  • June 16, 2004 at 4:23 pm

    #111568

    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

  • June 16, 2004 at 5:29 pm

    #510749

    Use 'set nocount', eg

    set nocount on

    select etc

    ...

    set nocount off

    Regards

    Phil

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

  • June 17, 2004 at 12:28 am

    #510759

    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