SQL - disparadores en sql

CREATE TRIGGER getLatestCap

ON  TestIDTable

AFTER insert

AS

BEGIN

    SET NOCOUNT ON;

    DECLARE @BID INT;

    DECLARE @Date Date;

    SET @BID = (SELECT BattID FROM inserted);

    SET @Date = (SELECT Test_Date FROM inserted);

    SELECT M_Cap, Cap_Date

    INTO #tempTable

    FROM CapDataTable

    WHERE BattID = @BID;

    -- Set the Test_Cap entry in TestIDTable to that capacity.

    UPDATE TestIDTable

    SET Test_Cap = (SELECT M_Cap

                    FROM #tempTable

                    WHERE Cap_Date = (SELECT max(Cap_Date)

                                      FROM #tempTable))

    WHERE BattID = @BID AND Test_Date = @Date;

END

GO

private void Setup()

{

        try

        {

            string BattSelect = "SELECT * FROM " + tbl;

            dt = new DataTable();

            Adpt = new SqlDataAdapter(BattSelect, ConnectionStr);

            builder = new SqlCommandBuilder(Adpt);

            Adpt.Fill(dt);

        }

        catch (Exception e)

        {

            MessageBox.Show("While Connecting to "+tbl+": " + e.ToString());

        }

    }

    private void UpdateDB()

    {

        try

        {

            Adpt.InsertCommand = builder.GetInsertCommand();

            Adpt.UpdateCommand = builder.GetUpdateCommand();

            Adpt.Update(dt);

        }

        catch (Exception e)

        {

            MessageBox.Show("While Updating " + tbl + ": " + e.ToString());

        }

    }