View limitations in sql server Part 42
C#, SQL Server, WCF, MVC and ASP .NET video tutorials for beginners
In this video we will learn about limitations of views in sql server
1. You cannot pass parameters to a view. Table Valued functions are an excellent replacement for parameterized views.
2. Rules and Defaults cannot be associated with views.
3. The ORDER BY clause is invalid in views unless TOP or FOR XML is also specified.
4. Views cannot be based on temporary tables.