Home Forums SQL Server 2008 SQL Server 2008 - General How to retrieve Table Variable data in a Trigger RE: How to retrieve Table Variable data in a Trigger

  • December 4, 2012 at 6:12 am

    #1565257

    Minnu (12/4/2012)

    Hi SSC Team,

    i have created a stored procedure with a "table variable" in it,

    inserted some records into table variable based on some conditions.

    and my requirement is :

    i have another trigger, i want to use the data available in table variable

    How it is possible.

    Please Help

    A table @variable will only hold is value for the session its in.

    Rather create a #temp table which you can use in your other 'trigger' then drop it after you have finished with it.