Queries in MS Access can act like views do in oracle in that you can query against them. Example: if you have a query in access called allProducts, you can also do
SELECT * from allProducts;
My questions is, what is the equivalent in Sql Server? I'm currently working on a project where we are converting all our ms access databases over to ms sql server. Tables get converted over to tables, but what about queries knowing very well our programmers used access queries as exampled above.