Output in insert..

  • Hi,

    How can we store the Output value(s) from insert command into a variable.. instead of storing it into a temp table.

    Regards,

    Guru

  • Hmm,

    You can't store the results of an OUTPUT clause into a variable, unless it's a table variable that has already been defined. If it's a table variable you are trying to use, it acts just like any other table in the clause.

    See the msdn article here.

  • Thanks Jim..

    Regards

    Guru

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

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