2005 and Triggers?

Hi all of you who've had a chance to play with 2005...
I have two quick questions with triggers in 2005.
1. Will there be available true "BEFORE" triggers as opposed to the "INSTEAD
OF" triggers?
2. Will triggers now be fire-able in a "FOR EACH ROW" style as opposed to
bulk triggers?
Thanks in advance,
- Arthur Dent.No to both of your questions. After triggers and instead-of triggers are
supported, and they fire per statement rather than per row.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in message
news:eadAqKt7FHA.3880@.TK2MSFTNGP12.phx.gbl...
> Hi all of you who've had a chance to play with 2005...
> I have two quick questions with triggers in 2005.
> 1. Will there be available true "BEFORE" triggers as opposed to the
> "INSTEAD OF" triggers?
> 2. Will triggers now be fire-able in a "FOR EACH ROW" style as opposed to
> bulk triggers?
> Thanks in advance,
> - Arthur Dent.
>|||Hello Arthur,

> 1. Will there be available true "BEFORE" triggers as opposed to the
> "INSTEAD OF" triggers?
Nope.

> 2. Will triggers now be fire-able in a "FOR EACH ROW" style as opposed
> to bulk triggers?
Nope.
Sorry, wish I had better news here.
Thank you,
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||"Arthur Dent" <hitchhikersguideto-news@.yahoo.com> wrote in
news:eadAqKt7FHA.3880@.TK2MSFTNGP12.phx.gbl:

> Hi all of you who've had a chance to play with 2005...
> I have two quick questions with triggers in 2005.
> 1. Will there be available true "BEFORE" triggers as opposed to the
> "INSTEAD OF" triggers?
> 2. Will triggers now be fire-able in a "FOR EACH ROW" style as opposed
> to bulk triggers?
> Thanks in advance,
> - Arthur Dent.
>
Don't use triggers. They are evil.
--== Posted via mcse.ms - Unlimited-Unrestricted-Secure Usenet News=
=--
http://www.mcse.ms The #1 Newsgroup Service in the World! 120,000+ New
sgroups
--= East and West-Coast Server Farms - Total Privacy via Encryption =--|||<me@.here.com> wrote in message
news:Xns9715F17487F66meherecom@.38.119.100.153...
> Don't use triggers. They are evil.
Why do you say that?
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--|||Hello Adam,

> Why do you say that?
Must have heard some MVP say it. :)
"Stuffing TURKEYS is evil."
Kent Tegels
DevelopMentor
http://staff.develop.com/ktegels/|||"Kent Tegels" <ktegels@.develop.com> wrote in message
news:b87ad74116b08c7bd1154e02e2f@.news.microsoft.com...
> "Stuffing TURKEYS is evil."
At least we both agree on that one :)
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--|||> 2. Will triggers now be fire-able in a "FOR EACH ROW" style as opposed to
> bulk triggers?
Could you explain exactly why you want to do that. There's bound to be
a better solution (i.e. set-based code rather than row-at-a-time).
David Portas
SQL Server MVP
--