Sqlserver Triggers
-
Hi, I want to return a trigger when new row is inserted or existing row is updated. if a row is inserted ,i have to return a trigger to my application.Later it is executed by our application to push data into our local database. It's urgent. can anyone help me for this? thanks sri
-
Hi, I want to return a trigger when new row is inserted or existing row is updated. if a row is inserted ,i have to return a trigger to my application.Later it is executed by our application to push data into our local database. It's urgent. can anyone help me for this? thanks sri
Why do you need your application to handle this? It seems like a bad idea. What if you write a second program that updates the data and forget about the trigger thing. Write a database trigger for Insert and/or Update or write a Stored Procedure that updates or inserts the data and does whatever other things you want done at the same time.
-
Hi, I want to return a trigger when new row is inserted or existing row is updated. if a row is inserted ,i have to return a trigger to my application.Later it is executed by our application to push data into our local database. It's urgent. can anyone help me for this? thanks sri
Member 4008492 wrote:
It's urgent
Of course it is. Triggers don't do that, they fire IN the DB.
Christian Graus Please read this if you don't understand the answer I've given you "also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
-
Hi, I want to return a trigger when new row is inserted or existing row is updated. if a row is inserted ,i have to return a trigger to my application.Later it is executed by our application to push data into our local database. It's urgent. can anyone help me for this? thanks sri
Hi Use the DB triggers (INSERT, UPDATE) in order to log the changes that occur on the table, then use that log todo what ever you want
-
Hi, I want to return a trigger when new row is inserted or existing row is updated. if a row is inserted ,i have to return a trigger to my application.Later it is executed by our application to push data into our local database. It's urgent. can anyone help me for this? thanks sri
Do a search on "SQL Server Notifications". Triggers fire in the database, and are not what you need here, but notifications might work for you.