Query vs View --- SQL Server vs MS Access
Posted on 2008-06-17
I know this may be a silly question, but what the heck...
1) Why does Microsoft call a "Query" a "View" in SQL Server but a "Query" in MS Access?
2) And, if a "Query" is called a view in SQL Server, then why does the MS SQL Server Management Studio have a toolbar called "Query Designer" and one called "View Designer"?
3) Plus, if a "Query" is called a view in SQL Server, then why is there a button named "New Query" on the "Standard" toolbar?
I'm sure these will be easy points for one or two of you :)