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 05, 2013 10:30 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 11:09 AM
Points: 583, Visits: 962
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
Post #1470811
Posted Friday, July 05, 2013 8:07 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 11:09 AM
Points: 583, Visits: 962
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
Post #1470892
Posted Saturday, July 06, 2013 3:38 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Today @ 11:56 AM
Points: 221, Visits: 1,692
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 06, 2013 8:40 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Tuesday, April 15, 2014 11:09 AM
Points: 583, Visits: 962
Thanks i got what writer meant to say..

Thanks a lot


Pramod
SQL Server DBA | MCSA SQL Server 2012
Post #1470959
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse