O'Reilly logo

SQL: Visual QuickStart Guide by Chris Fehily

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required