You develop a database application for a university. You need to create a view that will be indexed that meets the following requirements:
Displays the details of only students from Canada.
Allows insertion of details of only students from Canada.
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/ms187956.aspx