This tutorial is aimed at those of you with some experience with SQL and who want to discover the capabilities offered by some of its more advanced implementations. One of the main differences between the highly restricted Jet SQL behind Microsoft Access, and the more powerful Transact SQL used in Microsoft SQL Server 7 and SQL Server 2000 is that, wherever you can use a table, you can usually also use a query, a view, a union, or any type of JOIN statement.
|
