var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
When I write a sql joining more than views how will be executed?.
Does SQL Server execute each view and join the result set or interpret into one final sql and execute?
The process that SQL 2000 uses is closer to joining all of the SQL source code for the views, then executing the final syntax, but it isn't quite exactly either of the options that you presented.
Thanks for answering my questions.
You mean to say that SQL server comes with up final SQL and executes it not matter how many joins inside each views
Standard views are not precompiled, so the server is free to optimize as much as it is able.