SQL Server Reference
Betrifft: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
The SQL statement is the principal element in a Configuration Manager 2007 report that defines which data the report gathers and returns as the result set or multiple result sets. The topics in this section provide detailed information about the common functions and joins used in SQL statements and about using the query design tools found in SQL Server to help you to easily write effective SQL statements.
Inhalt dieses Abschnitts
- SQL Statement Reference
Provides detailed information and examples for using aggregate functions, joins, and the keyword phrase NOT IN.
- Query Design Tools
Provides information about using the query design tools found in SQL Server 2005 to create or modify queries in Configuration Manager reports.
- How to Create or Modify a Report SQL Statement Using Query Designer
Provides a step-by-step procedures to create or modify a report SQL statement using Query Designer in SQL Server 2005.
Weitere Informationen finden Sie unter Configuration Manager 2007 – Informationen und Support (möglicherweise in englischer Sprache).
Das Dokumentationsteam erreichen Sie per E-Mail unter: SMSdocs@microsoft.com