BEFORE Triggers

Hey,
Why doesn't SQL Server support BEFORE triggers?
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgHello,
Take a look into the INSTEAD OF Triggers in books online. Take a look into
the samples in below URL:-
http://www.sql-server-performance.com/nn_triggers.asp
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
> Hey,
> Why doesn't SQL Server support BEFORE triggers?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
> Hey,
> Why doesn't SQL Server support BEFORE triggers?
That's a question probably best asked of the development team.
The recommended solution is INSTEAD OF triggers.
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||Hi,
Yes, I know about INSTEAD OF triggers. I've used them, and it's just
annoying that to emulate a BEFORE trigger, you have to rewrite the
insert/update statements in the trigger. And, if you change the columns of
the table, you have to rewrite the trigger.
I did not ask "how to;" I asked "why not?" I was hoping for a [MFST]
response.
--
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eblGM6FYHHA.3256@.TK2MSFTNGP04.phx.gbl...
> Hello,
> Take a look into the INSTEAD OF Triggers in books online. Take a look into
> the samples in below URL:-
> http://www.sql-server-performance.com/nn_triggers.asp
>
> Thanks
> Hari
> "Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
> news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
>> Hey,
>> Why doesn't SQL Server support BEFORE triggers?
>> --
>> Thank you,
>> Daniel Jameson
>> SQL Server DBA
>> Children's Oncology Group
>> www.childrensoncologygroup.org
>

BEFORE Triggers

Hey,
Why doesn't SQL Server support BEFORE triggers?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
Hello,
Take a look into the INSTEAD OF Triggers in books online. Take a look into
the samples in below URL:-
http://www.sql-server-performance.com/nn_triggers.asp
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
> Hey,
> Why doesn't SQL Server support BEFORE triggers?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
|||"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
> Hey,
> Why doesn't SQL Server support BEFORE triggers?
That's a question probably best asked of the development team.
The recommended solution is INSTEAD OF triggers.

> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com
|||Hi,
Yes, I know about INSTEAD OF triggers. I've used them, and it's just
annoying that to emulate a BEFORE trigger, you have to rewrite the
insert/update statements in the trigger. And, if you change the columns of
the table, you have to rewrite the trigger.
I did not ask "how to;" I asked "why not?" I was hoping for a [MFST]
response.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eblGM6FYHHA.3256@.TK2MSFTNGP04.phx.gbl...
> Hello,
> Take a look into the INSTEAD OF Triggers in books online. Take a look into
> the samples in below URL:-
> http://www.sql-server-performance.com/nn_triggers.asp
>
> Thanks
> Hari
> "Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
> news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
>

BEFORE Triggers

Hey,
Why doesn't SQL Server support BEFORE triggers?
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.orgHello,
Take a look into the INSTEAD OF Triggers in books online. Take a look into
the samples in below URL:-
http://www.sql-server-performance.com/nn_triggers.asp
Thanks
Hari
"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
> Hey,
> Why doesn't SQL Server support BEFORE triggers?
> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>|||"Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
> Hey,
> Why doesn't SQL Server support BEFORE triggers?
That's a question probably best asked of the development team.
The recommended solution is INSTEAD OF triggers.

> --
> Thank you,
> Daniel Jameson
> SQL Server DBA
> Children's Oncology Group
> www.childrensoncologygroup.org
>
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||Hi,
Yes, I know about INSTEAD OF triggers. I've used them, and it's just
annoying that to emulate a BEFORE trigger, you have to rewrite the
insert/update statements in the trigger. And, if you change the columns of
the table, you have to rewrite the trigger.
I did not ask "how to;" I asked "why not?" I was hoping for a [MFST]
response.
Thank you,
Daniel Jameson
SQL Server DBA
Children's Oncology Group
www.childrensoncologygroup.org
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:eblGM6FYHHA.3256@.TK2MSFTNGP04.phx.gbl...
> Hello,
> Take a look into the INSTEAD OF Triggers in books online. Take a look into
> the samples in below URL:-
> http://www.sql-server-performance.com/nn_triggers.asp
>
> Thanks
> Hari
> "Daniel Jameson" <djameson@.childrensoncologygroup.org> wrote in message
> news:%23zkCGhFYHHA.3656@.TK2MSFTNGP05.phx.gbl...
>