SQL Quiz #10 – The OUTPUT Clause

Which of the following keywords must be used to prefix the column names in the OUTPUT clause?
Choose all that apply:

It is possible to redirect the results of the OUTPUT clause in a table, by adding an INTO clause.

What does this code do?

INSERT INTO RecipesHistory(IceCreamId, IngredientId, Quantity, ValidFrom, ValidTo)
OUTPUT
inserted.IceCreamId, inserted.IngredientId, inserted.Quantity, inserted.ValidFrom, inserted.ValidTo
INTO ExpiredRecipes_Temp(IceCreamId, IngredientId, Quantity, ValidFrom, ValidTo)
SELECT IceCreamId, IngredientId, Quantity, ValidFrom, ValidTo
FROM Recipes
WHERE ValidTo < GETDATE()


You can use the OUTPUT clause to return information about inserted and updated rows, but not about deleted rows.

What does the following code do?

UPDATE Recipes
SET Quantity = Quantity + 0.5
OUTPUT
inserted.Id,
deleted.Quantity AS Previous_Qty,
inserted.Quantity AS Current_Qty
WHERE IngredientId = 22 --(Milk)

In INSERT, UPDATE, and DELETE statements, you can only refer to columns from the target
table in the OUTPUT clause. In a MERGE statement you can refer to columns from both the
target and the source.

How many OUTPUT clauses can a single statement have?

How do you determine which action affected the OUTPUT row in a MERGE
statement?

When referring in the OUTPUT clause to columns from the inserted rows, when should
you prefix the columns with the keyword inserted?

Which of the following is only possible when using the MERGE statement in regard to
the OUTPUT clause?