Hi...

I have a table named Employee (with columns ID, Name, Surname) and another table named Employee_UPDATE (with columns ID, Sql_String).

I need a trigger(s). If I make an insert, update or delete on Employee, trigger should add the Sql string of the command into the Employee_Update table.

For example,
If a insert an item in Employee like ;
       500, Bill, Nash

Trigger must add the below string to the Employee_UPDATE

INSERT INTO Employee_UPDATE (Sql_String)
                 VALUES ('INSERT INTO Employee (ID. Name. Surname)
                             VALUES (500, Bill. John)'
                         )

I want to make such a things.
How can I do that?

Thanks for help...

I dont think you need an Id Column there in your Employee_UPDATE table. Anyways It is your call.

I dont think it would be possible to write it that way, as you say you wanted to store the SQL statement used for INSERT/UPDATE/DELETE operation. Coz, how can the trigger know what statement(DML) you used lastly, also unlike Stored Procedures/Functions the Triggers never take Parameters.

May be if you are tryin g to do this from your client application(Front end), this is possible.
Any time you run a DML(Data Manipulation Language) statement, you can format that string and simultaneously run the Insert on EMPLOYEE_UPDATE table with the Query you generated to Insert on EMPLOYEE table.

Anyone, correct me if I am wrong.

Cheers!

-Vijay G

Check this out:

http://vyaskn.tripod.com/tracking_sq...y_triggers.htm

Defiant,

That was great to know. You made me know that this is still possible. I learnt something new at the moment.

Thanks,


-Vijay G