hi
i want to create a trigger for update in mssql.
in my trigger i want to know which row was updated
how can i achieve this info ?
emilio
10
Junior Poster
Recommended Answers
Jump to PostWhen you create trigger After
ASplay with columns_updated() function read in http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx
All 2 Replies
Ramy Mahrous
401
Postaholic
Featured Poster
When you create trigger After AS play with columns_updated() function read in http://msdn.microsoft.com/en-us/library/aa258254(SQL.80).aspx
Doron_
0
Newbie Poster
Use the "inserted" keyword in the trigger.
if you use inside the trigger code:
SELECT * FROM inserted
only the updated rows will be returned.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.