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:39 am

    #1565282

    using a stored procedure inserted records in to a #Temp_Table.

    how to retieve the data in a Trigger

    am using below

    #Temp_Table

    ----------------------

    Id | Name

    ----------------------

    101Paint

    102Walls

    103Furn

    ----------------------

    Trigger:

    Create trigger Trigger_Name

    (

    ---

    ---

    )

    EXEC Stored_procedure @ID

    select * from #temp_table

    --

    But it is not working

    Syntax..Or query...

    .Plz