In SQL 2005, if i update any value of a column in a table..... how can i get the column name(it should only return column names when any of its value is updated)
shreyas2785
0
Newbie Poster
Recommended Answers
Jump to PostThat depends on where you're trying to capture the change. You can create a trigger for update/insert/delete to compare before and after values of a transaction. Are you trying to do this at the application level to show modifications or at the database level for audit trails?
All 4 Replies
sknake
1,622
Senior Poster
Featured Poster
shreyas2785
0
Newbie Poster
sknake
1,622
Senior Poster
Featured Poster
shreyas2785
0
Newbie Poster
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.