DRAG DROP
You create the following stored procedure. (Line numbers are included for reference only.)
You need to ensure that the stored procedure performs the following tasks:
If a record exists, update the record.
If no record exists, insert a new record.
Which four Transact-SQL statements should you insert at line 07? (To answer, move the
appropriate statements from the list of statements to the answer area and arrange them in
the correct order.)
![PrepAway - Latest Free Exam Questions & Answers](https://www.briefmenow.org/img/pa5.jpg)
Explanation:
Reference:
http://technet.microsoft.com/en-us/library/bb510625.aspx