| Author |
Topic |
|
Danny4003
Starting Member
40 Posts |
 Posted - 2006-10-25 : 16:42:42
|
Hi can anybody tell what is the best Trigger to use.!?Danny Dubroc  |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Danny4003
Starting Member
40 Posts |
Posted - 2006-10-25 : 16:59:34
|
| It was just a general question sorryDanny |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-25 : 17:19:26
|
| Is this an interview or homework question? The reason why I ask is that it is a very strange question to ask. There is no best trigger to use. If you need to use a trigger, for whatever reason, then you go with the one that fits your requirements.Tara Kizer |
|
|
|
Danny4003
Starting Member
40 Posts |
Posted - 2006-10-25 : 17:40:21
|
| okay thx. so just whatever i need to use it for i could?this is not an interview or homework. this is just a general question.I'm still pretty new at using SQL and I love it just a little confusing thats all.But I love it because I love using code. I wish I could learn other languages in a Code Aspect.However for right now I am using SQL for work and still trying to get very fluent with it.Thanks Danny |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-25 : 17:46:40
|
| Well you should avoid triggers at all costs. You will rarely need them if ever. I don't have a single trigger in my production environment.Tara Kizer |
|
|
|
Danny4003
Starting Member
40 Posts |
Posted - 2006-10-25 : 18:28:56
|
| I'm sorry but I must be kinda dumb but can you tell me the difference Between After and Instead of Triggers.Please bear with me; Break this down to where a very intermediate SQL Designer could understand.Thanks Danny |
|
|
|
Danny4003
Starting Member
40 Posts |
Posted - 2006-10-25 : 18:29:56
|
quote:
Originally posted by Danny4003
I'm sorry but I must be kinda dumb but can you tell me the difference Between After and Instead of Triggers.Please bear with me; Break this down to where a very intermediate SQL Designer could understand.Thanks Dannysorry Beginner not intermediate
|
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2006-10-25 : 18:41:05
|
| Have you looked in Books Online? |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2006-10-25 : 21:50:39
|
| I use triggers, but fr the simplest of tasks.For exampl, if I want to tract data audit/change issues, I use them, other than that I don't.I limit all of my database access to stored procedures, so I don't really need trigers.In a "wild West" environment they are probably needed more.But, They do impact performance if used unwisely.What's the question? Do you have something you need to accomplish?Oh, and there is no best ________(Whatever, fill in the blank) to use), you do what you need to doBrett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
|
What is the Best Trigger to use?