yes [ ] ' ' Microsoft SQL Server Parallel Data Warehouse Microsoft SQL Server 2008 R2 Parallel Data Warehouse Microsoft SQL Server 2012 Parallel Data Warehouse Datallegro SQL Server 2012 Parallel Data Warehouse 32 32 2100 2100 0 1000 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 ABS ACOS ASIN ATAN ACOT CEILING COS COT CURRENCY DEGREES DIVIDE EXP INT ISO.CEILING LN LOG LOG10 MAX MIN MOD MROUND POWER QUOTIENT RADIANS ROUND ROUNDDOWN ROUNDUP SIGN SIN SQRT SQRTPI TAN CONTAINSROW ISBLANK AND IF NOT OR SWITCH DATE DATEDIFF DAY EDATE EOMONTH HOUR MINUTE MONTH SECOND TIME WEEKDAY WEEKNUM YEAR COMBINEVALUES CONCATENATE DATEVALUE EXACT FIND LEFT LEN LOWER MID REPT RIGHT SEARCH SUBSTITUTE TIMEVALUE TRIM UNICHAR UNICODE UPPER VALUE KEEPFILTERS RELATED USERELATIONSHIP SUM MINA MAXA AVERAGE AVERAGEA STDEV.S STDEV.P VAR.S VAR.P COUNT COUNTA COUNTROWS DISTINCTCOUNT auto yes yes nosubsel no ( ) ( ) TOP () PERCENT WITH TIES ( SELECT ) (SELECT FROM DUAL ) Create Table () INSERT INTO VALUES () DISTINCT AS FROM ( on ) left outer join right outer join full outer join inner join cross join ( ) cross apply outer apply GROUP BY ORDER BY WHERE EXISTS () HAVING null primary key ( ) COALESCE(, CAST(-2 AS datetime)) COALESCE(, 0) , (CASE WHEN IS NULL THEN 0 ELSE 1 END) ASC DESC @ ? DATEPART( , ) year quarter month dayofyear day week weekday hour minute second millisecond * MIN MAX SUM ( ) COUNT ( ) STDEV STDEVP VAR VARP AVG ( ) ((SELECT MIN()) UNION (SELECT MAX())) (CASE WHEN COUNT_BIG(*) = COUNT_BIG() THEN ((SELECT MIN()) UNION (SELECT MAX())) ELSE ((SELECT MIN()) UNION (SELECT NULL)) END) SUM(CASE WHEN () IS NULL THEN CAST(1 AS BIGINT) END) SUM(CAST(1 AS BIGINT)) OVER () = <> > >= < <= IN AND OR + - / * ( ) LOWER() UPPER() LEN() LTRIM() RTRIM() RTRIM(LTRIM()) LOWER() UPPER() LEN() CAST(CAST( AS DATE) AS DATETIME) NCHAR() UNICODE() CAST( AS FLOAT) RTRIM(LTRIM()) DATEADD(SECOND, DATEDIFF(SECOND, 0, CAST( AS TIME)), '1899-12-30') () IN OR ( ) > < <> = >= <= ( ) CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') COALESCE(, CAST(-2 AS datetime)) COALESCE(, 0) CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') COALESCE(, CAST(-2 AS datetime)) COALESCE(, 0) ( ) ( = COLLATE DATABASE_DEFAULT) ( = ) ( = COLLATE DATABASE_DEFAULT OR IS NULL AND IS NULL) ( = OR IS NULL AND IS NULL) ((SELECT CASE WHEN Op1 = Op2 OR Op1 IS NULL AND Op2 IS NULL THEN 1 ELSE 0 END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) '' CAST(-2 AS datetime) 0 '' CAST(-2 AS datetime) 0 ( > ) ((SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) ((SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) ((SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) '' CAST(-2 AS datetime) 0 '' CAST(-2 AS datetime) 0 ( < ) ((SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) ((SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) ((SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) '' CAST(-2 AS datetime) 0 '' CAST(-2 AS datetime) 0 ( <= ) ((SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) ((SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) ((SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 < THEN 1 ELSE 0 END ELSE CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 > Op2 THEN 1 ELSE 0 END END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) '' CAST(-2 AS datetime) 0 '' CAST(-2 AS datetime) 0 ( >= ) ((SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) ((SELECT (CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) ((SELECT (CASE WHEN Op2 IS NULL THEN CASE WHEN Op1 < THEN 1 ELSE 0 END ELSE CASE WHEN Op1 IS NULL THEN CASE WHEN Op2 >= THEN 1 ELSE 0 END ELSE CASE WHEN Op1 < Op2 THEN 1 ELSE 0 END END END) FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) '' CAST(-2 AS datetime) 0 '' CAST(-2 AS datetime) 0 ( <> ) ((SELECT CASE WHEN Op2 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) ((SELECT CASE WHEN Op1 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) ((SELECT CASE WHEN Op1 = Op2 OR (Op1 IS NULL AND Op2 IS NULL) THEN 1 ELSE 0 END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 0) '' CAST(-2 AS datetime) 0 '' CAST(-2 AS datetime) 0 ( = ) ((SELECT CASE WHEN Op2 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) ((SELECT CASE WHEN Op1 IS NULL THEN 0 ELSE CASE WHEN Op1 = Op2 THEN 1 ELSE 0 END END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) ((SELECT CASE WHEN Op1 = Op2 OR (Op1 IS NULL AND Op2 IS NULL) THEN 1 ELSE 0 END FROM (SELECT AS Op1, AS Op2) as AuxTable) = 1) CAST( AS DATETIME) CAST( AS DATETIME) (SELECT COALESCE(Op1 + CAST(Op2 + 2 AS FLOAT), Op1, Op2) FROM (SELECT AS Op1, AS Op2) AS AuxTable) CAST( AS DATETIME) (SELECT COALESCE(Op1 + Op2, Op1) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(Op1 + Op2, Op1, CAST(Op2 - 2 AS DATETIME)) FROM (SELECT AS Op1, AS Op2) AS AuxTable) CAST( AS DATETIME) (SELECT COALESCE(Op1 + Op2, Op2) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(Op1 + Op2, CAST(Op1 - 2 AS DATETIME), Op2) FROM (SELECT AS Op1, AS Op2) AS AuxTable) ( + ) (SELECT COALESCE(Op1 + Op2, Op1) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE( + Op2, Op2) FROM (SELECT AS Op2) AS AuxTable) (SELECT COALESCE(Op1 + Op2, Op1, Op2) FROM (SELECT AS Op1, AS Op2) AS AuxTable) CAST( AS DATETIME) CAST( AS DATETIME) (SELECT COALESCE(Op1 - CAST(Op2 + 2 AS FLOAT), Op1, -2 - (Op2 + 2)) FROM (SELECT AS Op1, AS Op2) AS AuxTable) CAST( AS DATETIME) (SELECT COALESCE(Op1 - Op2, Op1) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(Op1 - Op2, Op1, CAST(-2 - Op2 AS DATETIME)) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(-2 + (Op1- (Op2 + 2)), -2 - (Op2 + 2)) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(-2 +(Op1- (Op2 + 2)), CAST(Op1 - 2 AS DATETIME), -2 - (Op2 + 2)) FROM (SELECT AS Op1, AS Op2) AS AuxTable) ( - ) (SELECT COALESCE(Op1 - Op2, Op1) FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE( - Op2, -Op2) FROM (SELECT AS Op2) AS AuxTable) (SELECT COALESCE(Op1 - Op2, Op1, -Op2) FROM (SELECT AS Op1, AS Op2) AS AuxTable) ( / ) ( / COALESCE(, 0)) ( * ( )) CAST( * AS money) ( * ) (SELECT CASE WHEN Op1 IS NULL THEN NULL ELSE CASE WHEN Op2 IS NULL OR Op2 = 0 THEN Op3 ELSE Op1 / Op2 END END FROM (SELECT AS Op1, AS Op2, AS Op3) AS AuxTable ) OR AND ( ) ROUND(, ) ROUND(, COALESCE(, 0)) ROUND((), (), 1) ROUND((), COALESCE((), 0), 1) (SELECT Op1 - Op2 * FLOOR(Op1 / Op2) FROM (SELECT () AS Op1, () AS Op2) AS AuxTable) (SELECT Op1 - Op2 * FLOOR(Op1 / Op2) FROM (SELECT () AS Op1, COALESCE((), 0) AS Op2) AS AuxTable) ROUND(() / (), 0, 1) ROUND(() / COALESCE((), 0), 0, 1) (LOG() / LOG()) (LOG() / LOG(COALESCE((), 0))) (LOG(COALESCE((), 0)) / LOG()) (LOG(COALESCE((), 0)) / LOG(COALESCE((), 0))) POWER((), ()) POWER((), COALESCE((), 0)) COALESCE((), ()) () % () (() / ()) (() / COALESCE((), 0)) (COALESCE((), 0) / ()) (COALESCE((), 0) / COALESCE((), 0)) Op1 COALESCE(Op1, '') COALESCE(Op1, 0) Op2 COALESCE(Op2, '') COALESCE(Op2, 0) (SELECT CASE WHEN < THEN Op1 ELSE Op2 END FROM (SELECT () AS Op1, () AS Op2) AS AuxTable) Op1 COALESCE(Op1, '') COALESCE(Op1, 0) Op2 COALESCE(Op2, '') COALESCE(Op2, 0) (SELECT CASE WHEN > THEN Op1 ELSE Op2 END FROM (SELECT () AS Op1, () AS Op2) AS AuxTable) COALESCE(, '') COALESCE(, 0) COALESCE(, '') COALESCE(, 0) (SELECT MAX(Op1) FROM (SELECT AS Op1 UNION ALL SELECT AS Op1) AS AuxTable) (SELECT MIN(Op1) FROM (SELECT AS Op1 UNION ALL SELECT AS Op1) AS AuxTable) COALESCE(, 0) (SELECT Op1 - Op2 * FLOOR(Op1 / Op2) FROM (SELECT AS Op1, AS Op2) AS AuxTable) POWER(CAST( AS FLOAT), ) ( / ) ROUND( / , 0, 1) ROUND(, ) ROUND(, , 1) (SELECT CEILING(ABS(Op1) * Op2) * SIGN(Op1) / Op2 FROM (SELECT AS Op1, POWER(10.0, ) AS Op2) AS AuxTable) (SELECT CASE WHEN Op2 = 0 THEN 0 ELSE ROUND(Op1/Op2, 0)*Op2 END FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT CASE WHEN Op1 IS NULL THEN NULL ELSE CASE WHEN Op2 = 0 THEN 0 ELSE ROUND(Op1/Op2, 0)*Op2 END END FROM (SELECT AS Op1, AS Op2) AS AuxTable) CEILING() (SELECT CASE WHEN Op2 = 0 THEN 0 ELSE CEILING(Op1/Op2)*Op2 END FROM (SELECT AS Op1, AS Op2) AS AuxTable) (SELECT CASE WHEN Op1 IS NULL THEN NULL ELSE CASE WHEN Op2 = 0 THEN 0 ELSE CEILING(Op1/Op2)*Op2 END END FROM (SELECT AS Op1, AS Op2) AS AuxTable) CEILING() (SELECT CASE WHEN Op2 = 0 THEN 0 ELSE CEILING(Op1/Op2)*Op2 END FROM (SELECT AS Op1, ABS() AS Op2) AS AuxTable) (SELECT CASE WHEN Op1 IS NULL THEN NULL ELSE CASE WHEN Op2 = 0 THEN 0 ELSE CEILING(Op1/Op2)*Op2 END END FROM (SELECT AS Op1, ABS() AS Op2) AS AuxTable) NOT() NOT() CAST((CASE WHEN () THEN 0 ELSE 1 END) AS BIT) (1 - ) COALESCE(1 - , 1) (-) ABS CEILING FLOOR SIGN SQRT SQUARE () EXP LOG LOG10 () (COALESCE((), 0)) COUNT_BIG( ) (COUNT_BIG(DISTINCT ) + MAX(CASE WHEN IS NULL THEN 1 ELSE 0 END)) COUNT_BIG(DISTINCT ) (CASE WHEN COUNT_BIG( ) = 0 THEN NULL ELSE COUNT_BIG( ) END) ABS() ASIN() ATAN() DEGREES() FLOOR() RADIANS() SIGN() SIN() SQRT() TAN() SQRT( * PI()) COALESCE(, 0) ACOS() (PI()/2 - ATAN()) COS() COT() EXP() LOG() LOG10() DAY() MONTH() YEAR() DATEPART(HOUR, ) DATEPART(MINUTE, ) DATEPART(SECOND, ) DATEPART(WEEK, ) DATEPART(ISO_WEEK, ) Cartridge error: Unsupported parameters for OpWEEKNUM. DATEPART(WEEKDAY, ) DATEPART(WEEKDAY, DATEADD(DAY, -1, )) DATEPART(WEEKDAY, DATEADD(DAY, -2, )) DATEPART(WEEKDAY, DATEADD(DAY, -3, )) DATEPART(WEEKDAY, DATEADD(DAY, -4, )) DATEPART(WEEKDAY, DATEADD(DAY, -5, )) DATEPART(WEEKDAY, DATEADD(DAY, -6, )) (DATEPART(WEEKDAY, DATEADD(DAY, -1, )) - 1) Cartridge error: Unsupported parameters for OpWEEKDAY. () COALESCE(, 0) () COALESCE(, 0) () COALESCE(, 0) DATEADD(mm, ((SELECT CASE WHEN AuxTable.Op1 < 1900 THEN AuxTable.Op1 ELSE AuxTable.Op1 - 1900 END FROM (SELECT AS Op1) as AuxTable) )*12 + - 1, 0) + ( - 1) (SELECT COALESCE(AuxTable3.Op1 + AuxTable3.Op3, AuxTable3.Op1 - 1, AuxTable3.Op3 - 1) FROM (SELECT COALESCE(DATEADD(MM, AuxTable2.Op1 + AuxTable2.Op2, 0), DATEADD(MM, AuxTable2.Op1 - 1, 0), DATEADD(MM, AuxTable2.Op2, 0)) AS Op1, AuxTable2.Op3 AS Op3 FROM (SELECT (CASE WHEN AuxTable.Op1 < 1900 THEN AuxTable.Op1 ELSE AuxTable.Op1 - 1900 END)*12 AS Op1, AuxTable.Op2 - 1 AS Op2, AuxTable.Op3 - 1 AS Op3 FROM (SELECT AS Op1, AS Op2, AS Op3) AS AuxTable) AS AuxTable2) AS AuxTable3) DATEADD(ss, (*3600 + *60 + )%(3600*24), -2) (SELECT DATEADD(ss, AuxTable2.Op1%(3600*24), -2) FROM (SELECT COALESCE(AuxTable.Op1 + AuxTable.Op2 + AuxTable.Op3, AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1 + AuxTable.Op3, AuxTable.Op2 + AuxTable.Op3, AuxTable.Op1, AuxTable.Op2, AuxTable.Op3) AS Op1 FROM (SELECT ()*3600 AS Op1, ()*60 AS Op2 , AS Op3) AS AuxTable) AS AuxTable2) () COALESCE(, CAST(-2 AS datetime)) () COALESCE(, 0) DATEADD(dd, -1, DATEADD(mm, DATEDIFF(m, 0, ) + 1 + , 0)) (SELECT DATEADD(dd, -1, DATEADD(mm, COALESCE(AuxTable.Op1 + 1 + AuxTable.Op2, AuxTable.Op1 + 1, AuxTable.Op2), 0)) FROM (SELECT DATEDIFF(m, 0, ) AS Op1, AS Op2) AS AuxTable) (SELECT DATEADD(mm, AuxTable.Op2, AuxTable.Op1) FROM (SELECT DATEDIFF(dd, 0, ) AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(DATEADD(mm, AuxTable.Op2, AuxTable.Op1), DATEADD(mm, AuxTable.Op2, CAST(-2 AS datetime)), DATEADD(mm, 0, AuxTable.Op1)) FROM (SELECT DATEDIFF(dd, 0, ) AS Op1, + 0 AS Op2) AS AuxTable) () COALESCE(, CAST(-2 AS datetime)) CAST((DATEPART(dw, CAST( AS datetime)) + @@DATEFIRST - 1) % 7 + 1 AS bigint) CAST((DATEPART(dw, CAST( AS datetime)) + @@DATEFIRST - 2) % 7 + 1 AS bigint) CAST((DATEPART(dw, CAST( AS datetime)) + @@DATEFIRST - 2) % 7 AS bigint) COALESCE(, 0) COALESCE(, 0) COALESCE(, 0) DATEADD(mm, ((SELECT CASE WHEN AuxTable.Op1 < 1900 THEN AuxTable.Op1 ELSE AuxTable.Op1 - 1900 END FROM (SELECT AS Op1) as AuxTable) )*12 + - 1, 0) + ( - 1) (SELECT COALESCE(AuxTable3.Op1 + AuxTable3.Op3, AuxTable3.Op1 - 1, AuxTable3.Op3 - 1) FROM (SELECT COALESCE(DATEADD(MM, AuxTable2.Op1 + AuxTable2.Op2, 0), DATEADD(MM, AuxTable2.Op1 - 1, 0), DATEADD(MM, AuxTable2.Op2, 0)) AS Op1, AuxTable2.Op3 AS Op3 FROM (SELECT (CASE WHEN AuxTable.Op1 < 1900 THEN AuxTable.Op1 ELSE AuxTable.Op1 - 1900 END)*12 AS Op1, AuxTable.Op2 - 1 AS Op2, AuxTable.Op3 - 1 AS Op3 FROM (SELECT AS Op1, AS Op2, AS Op3) AS AuxTable) AS AuxTable2) AS AuxTable3) DATEADD(ss, (*3600 + *60 + )%(3600*24), -2) (SELECT DATEADD(ss, AuxTable2.Op1%(3600*24), -2) FROM (SELECT COALESCE(AuxTable.Op1 + AuxTable.Op2 + AuxTable.Op3, AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1 + AuxTable.Op3, AuxTable.Op2 + AuxTable.Op3, AuxTable.Op1, AuxTable.Op2, AuxTable.Op3) AS Op1 FROM (SELECT ()*3600 AS Op1, ()*60 AS Op2 , AS Op3) AS AuxTable) AS AuxTable2) COALESCE(, CAST(-2 AS datetime)) COALESCE(, 0) DATEADD(dd, -1, DATEADD(mm, DATEDIFF(m, 0, ) + 1 + , 0)) (SELECT DATEADD(dd, -1, DATEADD(mm, COALESCE(AuxTable.Op1 + 1 + AuxTable.Op2, AuxTable.Op1 + 1, AuxTable.Op2), 0)) FROM (SELECT DATEDIFF(m, 0, ) AS Op1, AS Op2) AS AuxTable) (SELECT DATEADD(mm, AuxTable.Op2, AuxTable.Op1) FROM (SELECT DATEDIFF(dd, 0, CAST( AS DATE)) AS Op1, AS Op2) AS AuxTable) (SELECT COALESCE(DATEADD(mm, AuxTable.Op2, AuxTable.Op1), DATEADD(mm, AuxTable.Op2, CAST(-2 AS datetime)), DATEADD(mm, 0, AuxTable.Op1)) FROM (SELECT DATEDIFF(dd, 0, CAST( AS DATE)) AS Op1, + 0 AS Op2) AS AuxTable) COALESCE ( ) IS NULL ( ) nvarchar nvarchar varchar bit tinyint smallint int bigint tinyint smallint int bigint real float datetime datetime decimal varbinary decimal 1=1 1 1=0 0 ( ) ( , ) CAST( AS ) CAST(CAST( AS DATETIME) + 2 AS FLOAT) CAST( + 2 AS FLOAT) CAST(CASE WHEN THEN 1 ELSE 0 END AS FLOAT) CAST(CAST( AS DATETIME) + 2 AS FLOAT) CAST( + 2 AS FLOAT) CAST( AS FLOAT) CAST(CAST( AS DATETIME) + 2 AS BIGINT) CAST( + 2 AS BIGINT) (SELECT CAST(Op1 + CASE WHEN Op1 < 0 THEN -0.5 ELSE 0.5 END AS BIGINT) FROM (SELECT AS Op1) AS AuxTable) CAST(CASE WHEN THEN 1 ELSE 0 END AS BIGINT) CAST(CAST( AS DATETIME) + 2 AS BIGINT) CAST( + 2 AS BIGINT) CAST( as BIGINT) CAST(CAST( AS DATETIME) + 2 AS MONEY) CAST( + 2 AS MONEY) CAST(CASE WHEN THEN 1 ELSE 0 END AS MONEY) CAST(CAST( AS DATETIME) + 2 AS MONEY) CAST( + 2 AS MONEY) CAST( AS MONEY) ( <> CAST(-2 AS DATETIME)) (CAST( AS BIT) = 1) ( <> 0) CAST(CAST( AS DATETIME) + 2 AS BIT) CAST(CASE WHEN THEN 1 ELSE 0 END AS BIT) CAST( AS BIT) (CAST(CASE WHEN THEN 1 ELSE 0 END AS DATETIME) - 2) (CAST( AS DATETIME) - 2) CAST( AS DATETIME) (CASE WHEN = 1 THEN 'TRUE' ELSE 'FALSE' END) (CASE WHEN THEN 'TRUE' ELSE 'FALSE' END) CAST( AS NVARCHAR(4000)) CAST( AS VARCHAR(4000)) CAST( AS ) SQL90 cartridge error: OpCast: ResultType is not specified ( CASE WHEN THEN ELSE END ) RANK() DENSE_RANK() ROW_NUMBER() NTILE() OVER ( ) PARTITION BY CAST( AS bit) CAST( AS datetime) CAST( AS datetime) CAST( AS decimal) NULL