Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Authors
About us
Contact us
Newsletters
Write for us
Daily SQL Articles by email:
Sign up
Back
SQLServerCentral
Register
Home
»
SQL Server vNext
»
SQL Server 15 - Development
»
BEFORE TRIGGER Idea Posted to Microsoft...
BEFORE TRIGGER Idea Posted to Microsoft Connect
Post reply
Like
108
Add to Briefcase
1
2
Next
BEFORE TRIGGER Idea Posted to Microsoft Connect
View
Options
Author
Message
JediSQL
JediSQL
Posted Last year
#1877279
Ten Centuries
Group: General Forum Members
Points: 1194
Visits: 218
I have wished for SQL Server BEFORE TRIGGERs for a long time. I have posted to Microsoft Connect (their feedback service) about this a few time. I finally put in a post to which they responded "Thanks to this idea. We understand the requirement and we are putting it into the backlog... If this feature gets more votes it would be reconsidered in future releases." Please check out
https://connect.microsoft.com/SQLServer/feedback/details/3127222/before-trigger-behavior-with-execute-original-statement
and, if you like it, please vote it up.
Sincerely,
Daniel
9
Quote
Jeff Moden
Jeff Moden
Posted Last year
#1877283
SSC Guru
Group: General Forum Members
Points: 619447
Visits: 45201
I definitely voted that bad boy up. That was one of the things that I really liked about Oracle for the short 3 year stint that I had to work with it.
--Jeff Moden
RBAR
is pronounced ree-bar and is a Modenism for
R
ow-
B
y-
A
gonizing-
R
ow.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
9
Quote
Ed Wagner
Ed Wagner
Posted Last year
#1877330
SSC Guru
Group: General Forum Members
Points: 191121
Visits: 11907
I voted it up as well. It's now 4 up and 1 down. I have a "few" years of Oracle under my belt and, which I don't use triggers often, it would be handy to have.
Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
12
Quote
Jeff Moden
Jeff Moden
Posted Last year
#1877348
SSC Guru
Group: General Forum Members
Points: 619447
Visits: 45201
I just posted a plea and a link to this post on "the thread". I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers. I have little love in general for Oracle but this one of those things that Oracle absolutely did right from the git. It would make writing audit triggers a whole lot easier to prevent unnecessary duplication in audit tables, which become some of the biggest tables of them all.
--Jeff Moden
RBAR
is pronounced ree-bar and is a Modenism for
R
ow-
B
y-
A
gonizing-
R
ow.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
10
Quote
Hugo Kornelis
Hugo Kornelis
Posted Last year
#1877374
SSC-Forever
Group: General Forum Members
Points: 40936
Visits: 13469
+
x
Jeff Moden - Saturday, May 20, 2017 2:33 PM
I just posted a plea and a link to this post on "the thread". I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers. I have little love in general for Oracle but this one of those things that Oracle absolutely did right from the git. It would make writing audit triggers a whole lot easier to prevent unnecessary duplication in audit tables, which become some of the biggest tables of them all.
[/quote]
Another upvote. I like the idea in the item, allthough I'd like just implementing BEFORE triggers even better.
However, I do not share your dislike for INSTEAD OF triggers. They are a great tool for some specific purposes. I have used them to expose views as if they were the base tables, hiding the actual base tables, and allowing full updatability even when SQL Server itself would consider the view non-updatable or misunderstand how to change the base tables to correspond to the actual change,
Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
Visit my SQL Server blog:
http://sqlblog.com/blogs/hugo_kornelis
6
Quote
Ed Wagner
Ed Wagner
Posted Last year
#1877390
SSC Guru
Group: General Forum Members
Points: 191121
Visits: 11907
+
x
Hugo Kornelis - Sunday, May 21, 2017 3:03 AM
+
x
Jeff Moden - Saturday, May 20, 2017 2:33 PM
I just posted a plea and a link to this post on "the thread". I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers. I have little love in general for Oracle but this one of those things that Oracle absolutely did right from the git. It would make writing audit triggers a whole lot easier to prevent unnecessary duplication in audit tables, which become some of the biggest tables of them all.
Another upvote. I like the idea in the item, allthough I'd like just implementing BEFORE triggers even better.
However, I do not share your dislike for INSTEAD OF triggers. They are a great tool for some specific purposes. I have used them to expose views as if they were the base tables, hiding the actual base tables, and allowing full updatability even when SQL Server itself would consider the view non-updatable or misunderstand how to change the base tables to correspond to the actual change,
[/quote]
The more tools we have in our toolbox, the more choices we have to implement functionality. As long as they're written well, we can pick the right tool for the job.
Besides, AFTER triggers already exist, so aren't BEFORE triggers just logical?
Tally Tables - Performance Personified
String Splitting with True Performance
Best practices on how to ask questions
10
Quote
Jeff Moden
Jeff Moden
Posted Last year
#1877394
SSC Guru
Group: General Forum Members
Points: 619447
Visits: 45201
+
x
Hugo Kornelis - Sunday, May 21, 2017 3:03 AM
+
x
Jeff Moden - Saturday, May 20, 2017 2:33 PM
I just posted a plea and a link to this post on "the thread". I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers. I have little love in general for Oracle but this one of those things that Oracle absolutely did right from the git. It would make writing audit triggers a whole lot easier to prevent unnecessary duplication in audit tables, which become some of the biggest tables of them all.
Another upvote. I like the idea in the item, allthough I'd like just implementing BEFORE triggers even better.
However, I do not share your dislike for INSTEAD OF triggers. They are a great tool for some specific purposes. I have used them to expose views as if they were the base tables, hiding the actual base tables, and allowing full updatability even when SQL Server itself would consider the view non-updatable or misunderstand how to change the base tables to correspond to the actual change,
[/quote]
You misunderstand my dislike for "Instead Of" triggers. As you say, they ARE great for specific purposes. A perfect example is when the target of an insert is actually an updateable view built for one reason or another. Still, you have to control everything there instead of just what you need to control, whatever that may be.
--Jeff Moden
RBAR
is pronounced ree-bar and is a Modenism for
R
ow-
B
y-
A
gonizing-
R
ow.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair
Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
8
Quote
ALZDBA
ALZDBA
Posted Last year
#1877420
SSC Guru
Group: General Forum Members
Points: 85778
Visits: 9283
+
x
Jeff Moden - Sunday, May 21, 2017 11:20 AM
+
x
Hugo Kornelis - Sunday, May 21, 2017 3:03 AM
+
x
Jeff Moden - Saturday, May 20, 2017 2:33 PM
I just posted a plea and a link to this post on "the thread". I'd love to see "BEFORE Triggers" become a reality instead of those gosh-awful "Instead Of" triggers. I have little love in general for Oracle but this one of those things that Oracle absolutely did right from the git. It would make writing audit triggers a whole lot easier to prevent unnecessary duplication in audit tables, which become some of the biggest tables of them all.
Another upvote. I like the idea in the item, allthough I'd like just implementing BEFORE triggers even better.
However, I do not share your dislike for INSTEAD OF triggers. They are a great tool for some specific purposes. I have used them to expose views as if they were the base tables, hiding the actual base tables, and allowing full updatability even when SQL Server itself would consider the view non-updatable or misunderstand how to change the base tables to correspond to the actual change,
You misunderstand my dislike for "Instead Of" triggers. As you say, they ARE great for specific purposes. A perfect example is when the target of an insert is actually an updateable view built for one reason or another. Still, you have to control everything there instead of just what you need to control, whatever that may be.
[/quote]
Considered the new
Pirates of the Caribbean
is released in 2 days, guess how I read the '.
..ARE..
..' in this reply ( #Palmface ) ;-)
Johan
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere
-
How to post Performance Problems
-
How to post data/code to get the best help
-
How to prevent a sore throat after hours of presenting ppt ?
press F1 for solution, press
shift
+F1 for urgent solution
:-D
Need a bit of Powershell? How about
this
Who am I ?
Sometimes this is me
but
most of the time this is me
5
Quote
Brandie Tarvin
Brandie Tarvin
Posted Last year
#1877435
SSC Guru
Group: General Forum Members
Points: 113000
Visits: 9583
+
x
JediSQL - Friday, May 19, 2017 5:47 PM
I have wished for SQL Server BEFORE TRIGGERs for a long time. I have posted to Microsoft Connect (their feedback service) about this a few time. I finally put in a post to which they responded "Thanks to this idea. We understand the requirement and we are putting it into the backlog... If this feature gets more votes it would be reconsidered in future releases." Please check out
https://connect.microsoft.com/SQLServer/feedback/details/3127222/before-trigger-behavior-with-execute-original-statement
and, if you like it, please vote it up.
Done.
Brandie Tarvin, MCITP Database Administrator
LiveJournal Blog
:
http://brandietarvin.livejournal.com/
On
LinkedIn!
,
Google+
, and
Twitter
.Freelance Writer:
Shadowrun
Latchkeys: Nevermore
,
Latchkeys: The Bootleg War
, and
Latchkeys: Roscoes in the Night
are now available on Nook and Kindle.
5
Quote
Lynn Pettis
Lynn Pettis
Posted Last year
#1877531
SSC Guru
Group: General Forum Members
Points: 273629
Visits: 41200
InterBase had both BEFORE and AFTER Triggers. I liked that as well, and having them in SQL Server would be a great addition.
Lynn Pettis
For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here
or
when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here
and
here
Managing Transaction Logs
SQL Musings from the Desert
Fountain Valley SQL
(My Mirror Blog)
4
Quote
Go
Post reply
Like
108
Add to Briefcase
1
2
Next
Post quoted reply
Permissions
You
can't
post new topics.
You
can't
post topic replies.
You
can't
post new polls.
You
can't
post replies to polls.
You
can't
edit your own topics.
You
can't
delete your own topics.
You
can't
edit other topics.
You
can't
delete other topics.
You
can't
edit your own posts.
You
can't
edit other posts.
You
can't
delete your own posts.
You
can't
delete other posts.
You
can't
post events.
You
can't
edit your own events.
You
can't
edit other events.
You
can't
delete your own events.
You
can't
delete other events.
You
can't
send private messages.
You
can't
send emails.
You
can
read topics.
You
can't
vote in polls.
You
can't
upload attachments.
You
can
download attachments.
You
can't
post HTML code.
You
can't
edit HTML code.
You
can't
post IFCode.
You
can't
post JavaScript.
You
can
post emoticons.
You
can't
post or upload images.
Select a forum
SQL Server 2017
SQL Server 2017 - Administration
SQL Server 2017 - Development
SQL Server 2016
SQL Server 2016 - Administration
SQL Server 2016 - Development and T-SQL
SQL Server 2014
Administration - SQL Server 2014
Development - SQL Server 2014
SQL Server 2012
SQL 2012 - General
SQL Server 2012 - T-SQL
SQL Server vNext
SQL Server 15 - Administration
SQL Server 15 - Development
SQL Server 2008
SQL Server 2008 - General
T-SQL (SS2K8)
June 2007 CTP
Working with Oracle
July CTP
SQL Server Newbies
Security (SS2K8)
SQL Server 2008 High Availability
SQL Server 2008 Administration
Data Corruption (SS2K8 / SS2K8 R2)
SQL Server 2008 Performance Tuning
Cloud Computing
SQL Azure - Development
SQL Azure - Administration
Amazon AWS and other cloud vendors
General Cloud Computing Questions
CosmosDB
Azure Data Lake
Azure Machine Learning
Reporting Services
Reporting Services
Reporting Services 2005 Administration
Reporting Services 2005 Development
Reporting Services 2008/R2 Administration
Reporting Services 2008 Development
SSRS 2012
SSRS 2014
SSRS 2016
Programming
Connecting
General
SMO/RMO/DMO
XML
Service Broker
Powershell
Testing
TFS/Data Dude/DBPro
SSDT
Continuous Integration, Deployment, and Delivery
R Services and R Language
Data Warehousing
Integration Services
Strategies and Ideas
Analysis Services
Data Transformation Services (DTS)
Performance Point
Data Mining
PowerPivot
R language
Machine Learning
Database Design
Disaster Recovery
Design Ideas and Questions
Relational Theory
Hardware
Virtualization
Security and Auditing
SQLServerCentral.com
Anything that is NOT about SQL!
Contests!
Editorials
SQLServerCentral.com Announcements
SQLServerCentral.com Website Issues
Suggestions
Tag Issues with Content
Podcast Feedback
SQLServerCentral.com Test Forum
Articles Requested
SQL Server 2005
Administering
Backups
Business Intelligence
CLR Integration and Programming.
Data Corruption
Development
Working with Oracle
SQL Server 2005 Compact Edition
SQL Server 2005 General Discussion
SQL Server 2005 Security
SQL Server 2005 Strategies
SS2K5 Replication
SQL Server Express
SQL Server 2005 Performance Tuning
SQL Server 2005 Integration Services
T-SQL (SS2K5)
SQL Server Newbies
SQL Server 7,2000
Administration
Backups
Data Corruption
General
Globalization
In The Enterprise
Working with Oracle
Security
Strategies
SQL Server Newbies
Service Packs
SQL Server CE
Performance Tuning
Replication
Sarbanes-Oxley
T-SQL
SQL Server Agent
SQL Server and other platforms
MySQL
Oracle
PostgreSQL
DB2
SQL Server and Sharepoint
Older Versions of SQL (v6.5, v6.0, v4.2)
Older Versions of SQL (v6.5, v6.0, v4.2)
Career
Certification
Employers and Employees
Events
Job Postings
Resumes and Job Hunters
Presentations and Speaking
Retired Members
Testing Center
Question of the Day (QOD)
SQL Server Security Skills
Microsoft Access
Microsoft Access
Products and Books
Third Party Products
CA
SQLCentric
Extreme Technologies.
Innovartis
Embarcadero
SQL Sentry
Golden Gate Software
Idera
Lumigent
Red Gate Software
Quest Software
ApexSQL
Sonasoft
Discussions about Books
Discuss Programming Books
Discuss XML Books
Discuss Data Warehousing Books
Discuss T-SQL Books
Discuss DTS Books
Discuss SQL Server 2000 Books
Discuss SQL Server 7.0 Books
Notification Services
Administration
Article Discussions
Future Versions
SQL 12
Narrow your search by forum
Explore
Home
Latest
Popular
Calendar
Members
Who's on
Moderators
Forums
SQL Server 2017
SQL Server 2017 - Administration
SQL Server 2017 - Development
SQL Server 2016
SQL Server 2016 - Administration
SQL Server 2016 - Development and T-SQL
SQL Server 2014
Administration - SQL Server 2014
Development - SQL Server 2014
SQL Server 2012
SQL 2012 - General
SQL Server 2012 - T-SQL
SQL Server vNext
SQL Server 15 - Administration
SQL Server 15 - Development
SQL Server 2008
SQL Server 2008 - General
T-SQL (SS2K8)
June 2007 CTP
Working with Oracle
July CTP
SQL Server Newbies
Security (SS2K8)
SQL Server 2008 High Availability
SQL Server 2008 Administration
Data Corruption (SS2K8 / SS2K8 R2)
SQL Server 2008 Performance Tuning
Cloud Computing
SQL Azure - Development
SQL Azure - Administration
Amazon AWS and other cloud vendors
General Cloud Computing Questions
CosmosDB
Azure Data Lake
Azure Machine Learning
Reporting Services
Reporting Services
Reporting Services 2005 Administration
Reporting Services 2005 Development
Reporting Services 2008/R2 Administration
Reporting Services 2008 Development
SSRS 2012
SSRS 2014
SSRS 2016
Programming
Connecting
General
SMO/RMO/DMO
XML
Service Broker
Powershell
Testing
TFS/Data Dude/DBPro
SSDT
Continuous Integration, Deployment, and Delivery
R Services and R Language
Data Warehousing
Integration Services
Strategies and Ideas
Analysis Services
Data Transformation Services (DTS)
Performance Point
Data Mining
PowerPivot
R language
Machine Learning
Database Design
Disaster Recovery
Design Ideas and Questions
Relational Theory
Hardware
Virtualization
Security and Auditing
SQLServerCentral.com
Anything that is NOT about SQL!
Contests!
Editorials
SQLServerCentral.com Announcements
SQLServerCentral.com Website Issues
Suggestions
Tag Issues with Content
Podcast Feedback
SQLServerCentral.com Test Forum
Articles Requested
SQL Server 2005
Administering
Backups
Business Intelligence
CLR Integration and Programming.
Data Corruption
Development
Working with Oracle
SQL Server 2005 Compact Edition
SQL Server 2005 General Discussion
SQL Server 2005 Security
SQL Server 2005 Strategies
SS2K5 Replication
SQL Server Express
SQL Server 2005 Performance Tuning
SQL Server 2005 Integration Services
T-SQL (SS2K5)
SQL Server Newbies
SQL Server 7,2000
Administration
Backups
Data Corruption
General
Globalization
In The Enterprise
Working with Oracle
Security
Strategies
SQL Server Newbies
Service Packs
SQL Server CE
Performance Tuning
Replication
Sarbanes-Oxley
T-SQL
SQL Server Agent
SQL Server and other platforms
MySQL
Oracle
PostgreSQL
DB2
SQL Server and Sharepoint
Older Versions of SQL (v6.5, v6.0, v4.2)
Older Versions of SQL (v6.5, v6.0, v4.2)
Career
Certification
Employers and Employees
Events
Job Postings
Resumes and Job Hunters
Presentations and Speaking
Retired Members
Testing Center
Question of the Day (QOD)
SQL Server Security Skills
Microsoft Access
Microsoft Access
Products and Books
Third Party Products
CA
SQLCentric
Extreme Technologies.
Innovartis
Embarcadero
SQL Sentry
Golden Gate Software
Idera
Lumigent
Red Gate Software
Quest Software
ApexSQL
Sonasoft
Discussions about Books
Discuss Programming Books
Discuss XML Books
Discuss Data Warehousing Books
Discuss T-SQL Books
Discuss DTS Books
Discuss SQL Server 2000 Books
Discuss SQL Server 7.0 Books
Notification Services
Administration
Article Discussions
Future Versions
SQL 12
SQLServerCentral
Register
Search
Narrow your search by forum
Unthreaded, ascending
Unthreaded, descending
Subscribe to topic
Print topic
RSS feed
Go to topics forum
Jump to page
Jump to page
Copyright © 2002-2018 Redgate. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.