Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

 SQL Server Forums Profile | Active Topics | Members | Search | Forum FAQ Register Now and get your question answered!
 All Forums  Site Related Forums  The Yak Corral  Trigger Madness Reply to Topic  Printer Friendly
Author  Topic
Page: of 5

Kristen
Test

United Kingdom
22859 Posts

 Posted - 11/17/2005 :  00:44:46 Never did 1.8 times table at skool What's the matter with 16C = 61F (cold) and 28C = 82F (hot) ? Kristen

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2052 Posts

 Posted - 11/17/2005 :  03:34:07 quote:elwoos: what's the "F" thing that they put after their temperature figures?Hey Kristen, you're a lot older than me I thought you would know that steve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true!

Premature Yak Congratulator

India
22864 Posts

 Posted - 11/17/2005 :  04:26:13 >>Hey Kristen, you're a lot older than me I thought you would know thatI think he forgot it MadhivananFailing to plan is Planning to fail

Kristen
Test

United Kingdom
22859 Posts

 Posted - 11/17/2005 :  04:51:26 Forgot what?

Premature Yak Congratulator

India
22864 Posts

 Posted - 11/17/2005 :  04:57:53 Forgot of what you forgot MadhivananFailing to plan is Planning to fail Edited by - madhivanan on 11/17/2005 04:58:33

Kristen
Test

United Kingdom
22859 Posts

 Posted - 11/17/2005 :  05:54:36 Can you remind me what my password is here, thanks ...

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

 Posted - 11/17/2005 :  08:07:28 You mean 16C = 60.8F and 28C = 82.4F?I just remember that -40C = -40F, real, real cold.quote:Originally posted by KristenNever did 1.8 times table at skool What's the matter with 16C = 61F (cold) and 28C = 82F (hot) ? KristenCODO ERGO SUM

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

 Posted - 11/17/2005 :  08:17:29 More trigger madness:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=57883CODO ERGO SUM

steamngn
Constraint Violating Yak Guru

USA
306 Posts

 Posted - 11/17/2005 :  08:25:33 Here's two cents from an inexperienced newbie:I've learned a million things from everyone here (Thanks again!),and as Kristen and Brett know, I'm about to learn a helluva lot more about SQL with my new position. Several books that I have just purchased go into great detail about triggers, without somuch a even a mention of system overhead and the such. Even with my limited knowledge I can see that there are better ways than triggers, but triggers have an 'ok, that makes sense' look to them while constraints tend to leave the uneducated scratching their heads a bit. Read some trigger code in a book (or BOL), and it says something like 'Do this if that equals this or else do something different', while a constraint says the same thing in a very condensed way. Beginners have a hard time connecting the dots, I think. I'm reading, I'm reading!!Hey Brett, when are we having those Margaritas? And it is more like winter now, huh?andyThere's never enough time to type code right, but always enough time for a hotfix...

Kristen
Test

United Kingdom
22859 Posts

 Posted - 11/17/2005 :  08:31:11 "I just remember that -40C = -40F, real, real cold"When your spit (or whatever it might be, if you are really brave!) freezes before it hits the ground, eh?Kristen

elwoos
Flowing Fount of Yak Knowledge

United Kingdom
2052 Posts

 Posted - 11/17/2005 :  10:41:44 Kristen - did you forget that you'd hit enter -----------Facts are meaningless. You could use facts to prove anything that's even remotely true!

mcrowley
Aged Yak Warrior

771 Posts

 Posted - 11/17/2005 :  12:02:32 He's testing that functionality. You never know what a regression test is going to pick up. ;-)

Kristen
Test

United Kingdom
22859 Posts

 Posted - 11/17/2005 :  13:15:08 Bang! That's the regression test trigger firing ...

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

 Posted - 12/09/2005 :  15:58:27 More Trigger Madness:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58902CODO ERGO SUM

Sitka
Aged Yak Warrior

USA
571 Posts

 Posted - 12/09/2005 :  16:32:53 Response tohttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=58902Do you need to send an email notification within that trigger as well; You know?, to let the personknow the file has arrived, please let me know so I can better help you.That's too asshole to say in real life and it would takes days for me to write any trigger anyway."it's definitely useless and maybe harmful". Edited by - Sitka on 12/09/2005 16:33:43

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

 Posted - 06/29/2006 :  17:21:52 More Trigger Madness.Error updating an Access database from a trigger.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=68518CODO ERGO SUM

X002548
Not Just a Number

15586 Posts

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

USA
7020 Posts

 Posted - 06/29/2006 :  18:00:43 There is an endless variety of strange things people want to do with triggers.CODO ERGO SUM

Kristen
Test

United Kingdom
22859 Posts

 Posted - 06/30/2006 :  01:54:24 "trigger in mssql which should update a table in a msaccess database"I read that and went OMG ... but then I assumed it was just me, and didn't type a reply!I'll go and do it right now ..."Is there a Kristen Trigger that keeps this thread alive?"Just another Trigger Happy programmer!Kristen

jen
Flowing Fount of Yak Knowledge

Sweden
4110 Posts