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.
Select and Place:
Explanation:
http://msdn.microsoft.com/en-us/library/ms187926.aspx
http://msdn.microsoft.com/en-us/library/ms345415.aspx
CREATE PROCEDURE dbo.Spr_Table1 @InsertWord varchar(10), @Var1 int OUTPUT AS BEGIN
has to be the first Box. A function can’t instert into tables.