Microsoft Exam Questions

Which four Transact-SQL statements should you use?

DRAG DROP
You create a view based on the following statement:

You grant the Select permission to User1 for this view. You need to change the view so that
it displays only the records that were processed in the month prior to the current month. You
need to ensure that after the changes, the view functions correctly for User1. Which four
Transact-SQL statements should you use? (To answer, move the appropriate SQL
statements from the list of statements to the answer area and arrange them in the correct order.)

Answer:

Explanation:
http://msdn.microsoft.com/en-us/library/hh213020.aspx
http://msdn.microsoft.com/en-us/library/ms186819.aspx
http://msdn.microsoft.com/en-us/library/ms173846.aspx