Home Forums Article Discussions Article Discussions by Author Discuss content posted by pramod singla The OUTPUT clause and T-SQL Syntax RE: The OUTPUT clause and T-SQL Syntax

  • July 23, 2013 at 7:13 am

    #1634932

    Hugo Kornelis (7/23/2013)

    ...

    In other words - if the statement causes a trigger to fire, it should have either no OUTPUT clause or an OUTPUT clause with an INTO keyword. Using the OUTPUT clause without INTO (so that the results of the OUTPUT specification go to the client) is not allowed when a trigger fires.

    Thanks hugo for simple explanation.:-)

    Thanks
    Vinay Kumar
    -----------------------------------------------------------------
    Keep Learning - Keep Growing !!!