SQL Server tutorial for beginners - View limitations in sql server Part 42

5.0 (5)

35 learners

What you'll learn

This course includes

27 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

View limitations sql server sql view and order by create sql view with parameters sql use temp table in view sql view order by doesn't work sql view default value sql view default constraints

Full Transcript

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. Healthy diet is very important both for the body and mind. If you like Aarvi Kitchen recipes, please support by sharing, subscribing and liking our YouTube channel. Hope you can help. https://www.youtube.com/channel/UC7sEwIXM_YfAMyonQCrGfWA/?sub_confirmation=1 Text version of the video http://csharp-video-tutorials.blogspot.com/2012/09/limitations-of-views-part-42.html Slides http://csharp-video-tutorials.blogspot.com/2013/09/part-42-view-limitations.html Angular CRUD Tutorial https://www.youtube.com/watch?v=rJ9o4TyhSuo&list=PL6n9fhu94yhWUcq5Pc16uf8YKXoZ87Vh_ Angular CRUD Tutorial Text Articles & Slides http://csharp-video-tutorials.blogspot.com/2017/12/angular-crud-tutorial.html All Dot Net and SQL Server Tutorials in English https://www.youtube.com/user/kudvenkat/playlists?view=1&sort=dd All Dot Net and SQL Server Tutorials in Arabic https://www.youtube.com/c/KudvenkatArabic/playlists