yes [ ] ' ' Microsoft SQL Server Parallel Data Warehouse Microsoft SQL Server 2008 R2 Parallel Data Warehouse Datallegro 32 32 Provider Data Source Server Initial Catalog Database User ID UID Password PWD Integrated Security=SSPI Trusted_Connection=yes Microsoft.SqlServer.DataWarehouse Microsoft.DataWarehouse.Design.SqlSchema, Microsoft.DataWarehouse Microsoft.DataWarehouse.Controls.SqlClientQueryDesigner, Microsoft.DataWarehouse System.Data.OleDb Microsoft.DataWarehouse.Design.SqlSchema, Microsoft.DataWarehouse Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse System.Data.Odbc Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse auto yes yes nosubsel no ( ) ( ) FIRST ( SELECT ) DISTINCT AS FROM GROUP BY ORDER BY WHERE HAVING primary key ( ) ASC DESC @ ? DATEPART( , ) year quarter month dayofyear day week weekday hour minute second millisecond * COUNT MIN MAX SUM ( ) = <> > >= < <= IN AND OR + - / * ( ) IS NULL ( ) nvarchar nvarchar varchar bit tinyint smallint int bigint tinyint smallint int bigint real float datetime datetime decimal varbinary decimal ( ) ( , ) CAST( AS bit) CAST( AS datetime) CAST( AS datetime) CAST( AS decimal)