July 5, 2013 at 10:30 am
Which clause of the MERGE statement isn’t standard?
a. The WHEN MATCHED clause
B. The WHEN NOT MATCHED clause
c. The WHEN NOT MATCHED BY SOURCE clause
D. All MERGE clauses are standard
As per Training kit book its C..but i go for D
Just to be sure its C or D?
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
July 5, 2013 at 8:07 pm
One of the Geek sent me message specifying the answer as C
but how do you differenciate between standard and non standard clause?
I don't see such distinguishment in BOL...
http://technet.microsoft.com/en-us/library/bb510625.aspx
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
July 6, 2013 at 3:38 am
http://en.wikipedia.org/wiki/Merge_%28SQL%29
"Microsoft SQL extends with supporting guards and also with supporting Left Join via WHEN NOT MATCHED BY SOURCE clauses."
July 6, 2013 at 8:40 pm
Thanks i got what writer meant to say..
Thanks a lot
Pramod
SQL Server DBA | MCSE SQL Server 2012/2014
in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
May 8, 2015 at 5:04 am
Correct answer is "C", not "D".
Clauses, WHEN MATCHED and WHEN NOT MATCHED are the standards as per ANSI.
Microsoft extended these to WHEN NOT MATCHED BY SOURCE to make things more simpler for supporting some complex logic. But this clause does not involve Source tables and its columns. You can only use Target table columns here.
May 8, 2015 at 3:24 pm
Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
May 9, 2015 at 9:51 am
ScottPletcher (5/8/2015)
Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??
Heh.... exactly why I've never tried to get certified. Too much trivia that's available in BOL and not enough technique.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 13, 2015 at 1:58 pm
Jeff Moden (5/9/2015)
ScottPletcher (5/8/2015)
Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??Heh.... exactly why I've never tried to get certified. Too much trivia that's available in BOL and not enough technique.
Thank you A LOT for this.
A week or so ago was having a conversation with a co-worker who is knocking himself silly trying to amass certs. He believes this will achieve his goal of "as much money as possible." I suppose it could but there are no guarantees. He could be simply wasting his leisure time on a pursuit that will never pay off.
I quit chasing certs back at VB 4 and haven't had any problems being recruited, finding jobs I like, increasing pay scale as I go. I think it's more about what you can DO than how many tests you can pass. No one has cared about my lack of "credentials" and I'm glad I didn't waste my time.
It just feels good to "hear it" from a respected member of this board.
May 13, 2015 at 2:31 pm
herladygeekedness (5/13/2015)
Jeff Moden (5/9/2015)
ScottPletcher (5/8/2015)
Who comes up with such ridiculous, useless qs? And why on earth would a dba want to waste value time and brain space memorizing such trivialities??Heh.... exactly why I've never tried to get certified. Too much trivia that's available in BOL and not enough technique.
Thank you A LOT for this.
A week or so ago was having a conversation with a co-worker who is knocking himself silly trying to amass certs. He believes this will achieve his goal of "as much money as possible." I suppose it could but there are no guarantees. He could be simply wasting his leisure time on a pursuit that will never pay off.
I quit chasing certs back at VB 4 and haven't had any problems being recruited, finding jobs I like, increasing pay scale as I go. I think it's more about what you can DO than how many tests you can pass. No one has cared about my lack of "credentials" and I'm glad I didn't waste my time.
It just feels good to "hear it" from a respected member of this board.
Good to get your feedback too. I've had DBA candidates that keep talking only about their certs; I tend to never hire them. I'd rather they focused on learning and skills rather than certs. Particularly with the obscure one-liner oddities in BOL that certs seem to focus so much on.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
May 13, 2015 at 4:20 pm
Only two reasons I would get the certs right now. One, if my employer came to me and said it was a requirement for my job. Two, validation of my skills and knowledge. Number one hasn't happened and I don't seem to have the time to accomplish number two. Guess it isn't a priority at this time.
May 13, 2015 at 5:10 pm
Lynn Pettis (5/13/2015)
Only two reasons I would get the certs right now. One, if my employer came to me and said it was a requirement for my job. Two, validation of my skills and knowledge. Number one hasn't happened and I don't seem to have the time to accomplish number two. Guess it isn't a priority at this time.
For #1, it might cause me to update my resume. For #2, all someone has to do is a simple Yabingooglehoo on "Lynn Pettis" and they'll get instant validation of your skills and knowledge. If that's not good enough for someone, I'd be happy to write a letter of recommendation and I'm sure that several others on this forum would be happy to do the same for you or any of the other heavy hitters on this and other forums.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 13, 2015 at 5:36 pm
Certifications don't prove much, if anything. If I can get one, a trained monkey can.
There are several MVPs here in town (Joe, Dr SQL, Kevin...) and all of them have written either whole books on SQL Server or chapters in SQL Server Deep Dives, so they know what they're talking about.
Know how many certifications they have between them?
That's right, NONE.
Certifications are, I think, a way for employers to try to validate a skillset they don't understand. Just because you can pass an exam doesn't mean much, especially when it's multiple choice. Show what you've fixed/dealt with. That means something.
May 13, 2015 at 6:01 pm
There's always an exception to every rule... in this case, it would be the good folks that earned an MCM.
--Jeff Moden
Change is inevitable... Change for the better is not.
May 13, 2015 at 7:27 pm
I actually just took this exam last week. Yes much more of a trivia contest then a measure of skill. I'm doing the MCSA track because my employer is paying for it, helps get them Gold Certified and pushes me into SQL nuggets I might not encounter in my day to day. But a measure of skill the certs are not.
If Certs measured skill they should have some called SQL Bad @$$ for Lynn and Jeff.:-)
***SQL born on date Spring 2013:-)
May 13, 2015 at 8:49 pm
Jeff,
I would agree the MCM is a different beast. It's more realistic (and difficult) than the standard multiple choice tests. Even I can pass those!
Viewing 15 posts - 1 through 15 (of 17 total)
You must be logged in to reply to this topic. Login to reply