Trigger to insert New Value And Old Value after update and before update

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Dear All,

please i want to create trigger that will insert into another table the old value and new value

and how can i pass values from my C# application

can any one help for this pleaseeeee

thanks

Posted 19-Aug-13 20:06pm

leito6266

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

pradiprenushe · Answer 1 · 2013-08-19T20:18:00

Solution 1

Try this use after trigger

SQL

CREATE TRIGGER ShowUpdate on YourTable
AFTER  UPDATE
AS
BEGIN
INSERT INTO NewDataTable
   SELECT id, name  FROM inserted

INSERT INTO OldDataTable
   SELECT id, name  FROM Deleted 
END

Posted 19-Aug-13 20:18pm

pradiprenushe

Updated 19-Aug-13 20:26pm

v3

Comments

leito6266 20-Aug-13 13:25pm

thanks for your help
it's fine now
but i have another thing to do in the table which i want to insert into by trigger i have one column which i have to pass parameter from my application how can i do that by trigger

pradiprenushe 20-Aug-13 13:40pm

Look here three tables are given. You can use normal update query to get value from application & fire update query on you table. Then this trigger happens. So you dont need input in trigger. Please clarify am i getting you correctly? or else elaborate some more info with some exammple

pradiprenushe 20-Aug-13 13:54pm

If you still want to pass data refer this link
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/da4d8620-92b7-4354-90e8-103d820559f6/set-context-info-is-not-global