Hot answers tagged

7 votes
Accepted

Trigger execution order after delete

From the docs: An AFTER trigger is run only after the triggering SQL statement has run successfully. This successful execution includes all referential cascade actions and constraint checks ...
user avatar
  • 5,768
2 votes

Can't create MS SQL Server trigger

Namespaces are confusing and not well documented in SQL Server. In your case, there will be another schema-scoped object in the database with the same identifier as the one you are hoping to use for ...
user avatar
  • 71k
2 votes

Normalizing an old database

"Require no application code changes" is the right way to go at this stage. Another alternative is to fully normalize the consumer table, which would remove the columns "firstname" ...
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible