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
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.