Limitations of views.- cant parameters, rules and default, Order by unless Top or For XML, cant temp table

Limitations:

1. you can not pass parameters to a view. Table valued functions are the replacement for parametrized views.

2. rules and defaults can not be associated with views.

3. The order by clause is invalid in views unless TOP or FOR XML is not specified.

4. views can not be based on temporary tables.