O'Reilly logo

Discovering SQL: A Hands-On Guide for Beginners by Alex Kriegel

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 2008 EXPRESS

There is no lack of tools to access the Microsoft SQL Server, from the built-in graphical console SQL Server Management Studio, to the commanA-line interface SQLCMD, to thirA-party utilities such as Quest SQL Server Management Tools and open source SQuirreL introduced in Appendix D.

SQL Server Management Studio Express

The Management Studio is an integral part of SQL Server and is available as an adA-on for the Express editions. It is the primary tool for administering the SQL Server installation, and we are going to use but a small piece of it: the Query Analyzer.

  1. Start up the SQL Server Management Studio from Programs images Microsoft SQL Server 2008 images SQL Server Management Studio, and log onto your SQL Server installation, as shown in Figure A-20.

    images

    FIGURE A-20

  2. Once the Management Studio consoler is up, click the New Query button at the top-left corner of the console, as shown in Figure A-21.

    images

    FIGURE A-21

  3. Load the file DiscoveringSQL.MSSQLServer.Library.sql into the new query window by clicking the Open File icon on the Studio Management toolbar or by opening ...

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