Microsoft Exam Questions

You need to create a single object that inserts a provided value into Table1, and then returns a cou

DRAG DROP
You use SQL Server 2014.
You need to create a single object that inserts a provided value into Table1, and then returns
a count of the records in Table1.
Develop the solution by selecting and arranging the required code blocks in the correct
order. You may not need all of the code blocks.

Answer: See the explanation.

Explanation:

Box 1:

Box 2:

Box 3:

Box 4: