Select from following answers:- Views cannot be relied on Temporary tables
- If TOP or FOR XMl are used then using OrderBy Clause is invalid
- We cannot pass parameters to VIEWS
- All of the Above
- All Above
All the above mentioned sentences are the limitations of VIEW.
Sample VIEW example :
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator