Which four Transact-SQL statements should you use?

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.)
Select and Place:

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.)
Select and Place:

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



Leave a Reply 1

Your email address will not be published. Required fields are marked *


Joe

Joe

2-5-4 is correct.

But if you have to choose four statements (Which four Transact-SQL statements should you use?) it is 2-5-4-6.