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.)
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
I would agree with answer provided. The view was not created with schema binding.
(See answer from question 97 to see how view was created.)
0
0
But why does the text talk about four statements, although the answer contains only 3?
0
0
I am also wondering why
0
0