III.4.1. Configuring Query Options with Performance and Control Parameters

The Execution options allow you to specify many different parameters for your query. Parameters are specified on three separate pages:

  • General: Basic query settings, such as how many rows can be returned.

  • Advanced: Many advanced settings, such as those that can be configured with SET statements, are selectable on this page.

  • ANSI: Transact-SQL is ANSI compliant — it can be configured to comply with ANSI specifications. The ANSI settings allow you to modify the specifications to either comply with ANSI specifications, or work according to business rules.

To access the Query Options dialog box, follow these steps:

  1. Launch SQL Server Management Studio (SSMS) by choosing StartAll ProgramsMicrosoft SQL Server 2008SQL Server Management Studio.

  2. Click the New Query button to open a new query window.

  3. Right-click the query window and choose Query Options.

    You can also select the Query drop-down menu and choose Query Options. The Query Options dialog box appears, as shown in Figure 4-1. The Query Options dialog box defaults to Execution | General.

    Figure III.4-1. The General settings of the Query Options dialog box.

III.4.1.1. ...

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® 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.

Start your free trial