Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

MCSA 70-461 Question Expand / Collapse
Author
Message
Posted Friday, July 5, 2013 10:30 AM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 608, Visits: 1,053
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 | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1470811
Posted Friday, July 5, 2013 8:07 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 608, Visits: 1,053
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 | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1470892
Posted Saturday, July 6, 2013 3:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 4:09 AM
Points: 225, Visits: 1,755
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."
Post #1470906
Posted Saturday, July 6, 2013 8:40 PM


SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 608, Visits: 1,053
Thanks i got what writer meant to say..

Thanks a lot


Pramod
SQL Server DBA | MCSA SQL Server 2012

in.linkedin.com/in/pramodsingla/
http://pramodsingla.wordpress.com/
Post #1470959
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse