Microsoft SQL Server

Whereas Microsoft Access is desktop software, Microsoft SQL Server is Microsoft’s server software that supports very large databases and numbers of transactions. It runs only on Microsoft operating systems. You can learn about SQL Server at www.microsoft.com/sql/. You can download a free 120-day evaluation version of SQL Server from www.microsoft.com/sql/evaluation/.

This book covers Microsoft SQL Server 2000. To determine which version of Microsoft SQL Server you are running, type SELECT @@VERSION;, press Enter, type go, and press Enter at an osql prompt.

You can use the SQL Query Analyzer graphical tool or the osql command-line utility to run SQL programs.

To use SQL Query Analyzer:

1.
Choose Start > Programs > Microsoft ...

Get SQL: Visual QuickStart Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.