Microsoft SQL Server 2005 New Features

queries, testing with Query Builder, 178

Query Analyzer, replacement of, 25, 29

Query Builder, displaying in Report Wizard, 177

Query Editor, features of, 29–30, 41–42. See also MDX Query Editor

Query() method, using with XML data types, 148–149

question mark (?), effect of placing in Filter column of Query Builder, 178

queue application design, relationship to SQL Server Service Broker, overview of, 127–128

queues

creating for SQL Server Service Broker application, 135

providing locking mechanisms for, 129

retrieving messages from, 136–138

sending messages to, 135–136

using stored procedures with, 130