4 Kicks

Trigger and number of rows affected(beyondrelational.com)

submitted by jacobsebastianjacobsebastian(3639) 1 year, 1 month ago

One of my frieds told me that INSERT trigger will not fire if no data are added to the main table. It is a mistake that some people think that triggers will not fire if no row is affected. Note that trigger is event based and not data based. Here is a proof that trigger fires eventhough no row is affected...

add a comment |category: |Views: 28

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:
dotnetterdotnetter(0) - MadhivananMadhivanan(90) - d312d312(832) - jacobsebastianjacobsebastian(3639)
Comments:

No comments so far

information Login or create an account to comment on this story
Submit a Story
View upcoming stories
How else can I help?
Add our feeds to your site

Most Active Users

What's this?