Could you please also tell us the reason of these VIEW limitations, like: - Why SQL Server doesn't allow to pass a parameter to a VIEW? - Why we have to use TOP clause while using ORDER BY ?
+Aditya Samanta I guess Views for allowing non technical or least tech persons (maybe also for tech persons) to query and display data, Functions for making calculations or similar things and Procedures to execute large no of queries at a time without needing to write thousands of lines of queries again and again.
you should append a give a like message at the end of your videos I'm sure many people are watching the playlists like myself and we are forgetting to give it a like, I recommend at least once at the end of each video, because people like myself are most likely forgetting after the third video.
I have one question,can anyone pls have a look : The inline table value function he created is based on the table, means the function is actually calling a table and not view @4:35
Brother, he said we can use inline valued functions when we need to apply parameters For example, if we need only males so we can apply inline function instead of using view because view doesn't allow us to apply parameters.
#Stuti# #Tehri# bro its imp when u wnt to give some limitations to outside users . so u can just create a view according to user needs and then u can grant tht view so he will b able to see nly those records which are stored by a view :)
Views are very useful. You can use them to create an abstraction between tables and the user. You can then make changes to the view without the need of changing user code. Also it is useful for complex queries and reuse.
your style of teaching in awesome!
Way of explanation is Awesome
Well done! You are my favorite tutor in You Tube. Do you have tutorials for advance SQL server 2012?
you are superb tutor...!!!
Thanx for sharing your knowledge...keep it up
Nice explanation
Hello Venkat, your videos are very useful. At this time time i want to know why we are unable to use order by clause while creating view... Thank you
Could you please also tell us the reason of these VIEW limitations, like:
- Why SQL Server doesn't allow to pass a parameter to a VIEW?
- Why we have to use TOP clause while using ORDER BY ?
answer for ur first question because it doesnt store data
You have covered Procedures, Functions, and View - I was wondering which should be used when ?
+Aditya Samanta I guess Views for allowing non technical or least tech persons (maybe also for tech persons) to query and display data, Functions for making calculations or similar things and Procedures to execute large no of queries at a time without needing to write thousands of lines of queries again and again.
you should append a give a like message at the end of your videos I'm sure many people are watching the playlists like myself and we are forgetting to give it a like, I recommend at least once at the end of each video, because people like myself are most likely forgetting after the third video.
Hi Sir
Could you please post the tutorial about SQL Performance Tuning?
Nice video. Thank You.
pure awesomeness!
awesome explanation
Awesome!
Good Explanation Thanks...
Revisiting
Thanks a lot
i don't know why those 2 dislikes the videos?
I have one question,can anyone pls have a look :
The inline table value function he created is based on the table, means the function is actually calling a table and not view @4:35
Brother, he said we can use inline valued functions when we need to apply parameters
For example, if we need only males so we can apply inline function instead of using view because view doesn't allow us to apply parameters.
Inline table value function is the replacement of PARAMETERIZED view.
I guess views are not of much important
#Stuti# #Tehri# bro its imp when u wnt to give some limitations to outside users . so u can just create a view according to user needs and then u can grant tht view so he will b able to see nly those records which are stored by a view :)
Views are very useful. You can use them to create an abstraction between tables and the user. You can then make changes to the view without the need of changing user code. Also it is useful for complex queries and reuse.