Truy vấn lựa chọn Khi hàng loạt được gửi từ các Editor truy vấn đến SQL Server, một số thiết lập tùy chọn tìm kiếm sẽ được kèm với hàng loạt các. Các mặc định cho các cài đặt này có thể được đặt trong Công cụ ➪ Tùy chọn ➪ Truy vấn Thi ➪ Server SQL. | Part I Laying the Foundation TABLE 6-1 Useful Query Editor Shortcuts Shortcut Description Ctrl Shift R Refresh IntelliSense Ctrl K K Add or remove a bookmark Ctrl K A Enable all bookmarks Ctrl K N Move to the next bookmark Ctrl K P Move to the previous bookmark Ctrl K L Clear all bookmarks Ctrl K C Comment the selection Ctrl K U Uncomment the selection Ctrl K W Open the Bookmark window Query options When a batch is sent from the Query Editor to SQL Server several query option settings are included with the batch. The defaults for these settings can be set in Tools O Options O Query Execution O SQL Server. The current query options can be viewed or changed in Query O Query Options as shown in Figure 6-9. FIGURE 6-9 Advanced and ANSI query options can be viewed and set using the Query Options dialog. This view shows the Advanced Query Options. 122 Using Management Studio 6 Executing SQL batches As a developer s tool the Query Editor is designed to execute T-SQL batches which are collections of multiple T-SQL statements. To submit a batch to SQL Server for processing use Query O Execute Query click the Run Query toolbar button use the F5 key or press Ctrl E. Personally I ve always wanted a large button like the Staples Easy button plugged into USB and programmed to F5 that I can slam to execute the query. Because batches tend to be long and it s often desirable to execute a single T-SQL command or a portion of the batch for testing or stepping through the code the SQL Server team provides you with a convenient feature. If no text is highlighted then the entire batch is executed. If text is highlighted only that text is executed. You ll learn more about this in Chapter 21 Programming with T-SQL but technically when the Query Editor sends the script to SQL Server it breaks it up into smaller batches separated by the batch separator - go. It s worth pointing out that the Parse Query menu command and toolbar button checks only the SQL code. It does .
