Select from following answers:- CREATE PROCEDURE
- CREATE VIEW
- DROP PROCEDURE
- All Above
You should use the CREATE VIEW statement. Users can execute select queries against views. You could create a view on the Sales table that was defined so that the Country column equaled the value India.
You should not use the CREATE PROCEDURE statement. Users cannot execute select queries against stored procedures.
Show Correct Answer
Source: Microsoft Press book | |
Alert Moderator