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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.