August 16, 2018 at 9:31 pm
Comments posted to this topic are about the item Using UPDATE()
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 16, 2018 at 11:02 pm
Nice question to end the week on, thanks, Steve
____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
βlibera tute vulgaris exβ
August 17, 2018 at 1:14 am
got it wrong but learnt something new,
cheers Steve
---------------------------------------------------------------------------------------
The more you know, the more you know that you dont know
August 17, 2018 at 7:42 am
Heh... this will make a good, quick ice-breaker question for interviews like the "How do you get the current date and time in T-SQL". Litmus strips anyone? π
--Jeff Moden
August 17, 2018 at 8:11 am
Jeff Moden - Friday, August 17, 2018 7:42 AMHeh... this will make a good, quick ice-breaker question for interviews like the "How do you get the current date and time in T-SQL". Litmus strips anyone? π
Well, the real answer is of course "only in some kinds of trigger". The UPDATE() function can't be used in DDL triggers, or in Logon triggers, or in INSERT triggers - only in DELETE and UPDATE (DML) triggers - so there are more kinds of trigger that it can't be used in than kinds that it can be used in.
Tom
August 17, 2018 at 8:36 am
TomThomson - Friday, August 17, 2018 8:11 AMJeff Moden - Friday, August 17, 2018 7:42 AMHeh... this will make a good, quick ice-breaker question for interviews like the "How do you get the current date and time in T-SQL". Litmus strips anyone? πWell, the real answer is of course "only in some kinds of trigger". The UPDATE() function can't be used in DDL triggers, or in Logon triggers, or in INSERT triggers - only in DELETE and UPDATE (DML) triggers - so there are more kinds of trigger that it can't be used in than kinds that it can be used in.
True enough but I'm shooting really low here... There have been many resumes I've been through where the candidate claims that they've written triggers but then can't tell me a thing about what the INSERTED or DELETED logical tables actually are. Asking about UPDATE() is a nice short question that will allow me to quickly determine how full the candidate's ditty bag might actually be... or not. π Again, "Litmus Strip". If they know their stuff, I would expect them to follow up with a bit more information like what you just said.
--Jeff Moden
August 17, 2018 at 10:21 am
Jeff Moden - Friday, August 17, 2018 7:42 AMHeh... this will make a good, quick ice-breaker question for interviews like the "How do you get the current date and time in T-SQL". Litmus strips anyone? π
For sure
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
August 17, 2018 at 1:33 pm
Nice question for a Friday. Thanks Steve.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply