SQL Server: Date Change Capture without Using Trigger (connectsql.blogspot.com)

submitted by lionofdezertlionofdezert(1110) 11 months, 23 days ago

Most of SQL Server users think that trigger is the only place where we can use DELETED and INSERTED virtual tables to capture data change in result of any INSERT, UPDATE or DELETE statement. Simple insert,update or insert queries can be modified to capture change data.

add a comment |category: |Views: 16

tags: another

new Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

  • "Kick It" text
  • "Kick It" background
  • kick count text
  • kick count background
  • border

Simply copy and paste this HTML into your blog post.


Users who kicked this story:
Comments:

No comments so far

information Login or create an account to comment on this story