yes [ ] N ' Microsoft SQL Server.11 Microsoft SQL Server.12 Microsoft SQL Server.13 Microsoft SQL Server.14 Microsoft SQL Server.15 Microsoft SQL Server.16 Microsoft SQL Server.17 YYYYMMDD HH:MM:SS TABLOCK,FIRE_TRIGGERS 1 2 1 17 21 SQLLIKE 16 64 64 2100 2100 0 1000 1000 Provider Data Source Server Initial Catalog Database User ID UID Password PWD Integrated Security=SSPI Trusted_Connection=yes System.Data.SqlClient Microsoft.DataWarehouse.Design.SqlSchema, Microsoft.DataWarehouse.AS Microsoft.DataWarehouse.Controls.SqlClientQueryDesigner, Microsoft.DataWarehouse.AS System.Data.OleDb Microsoft.DataWarehouse.Design.OleDbSchema, Microsoft.DataWarehouse.AS Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse.AS System.Data.Odbc Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse.AS 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 IF.EAGER NOT OR SWITCH DATE DATEDIFF DAY EDATE EOMONTH HOUR MINUTE MONTH QUARTER 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 HASH BITAND BITOR BITXOR auto yes I8 BOOL R8 I8 CY R8 I8 CY I8 R8 R8 DATE DATE DATE DATE DATE DATE STR STR STR STR DATESTR yes nosubsel no ( ) ( ) TOP () PERCENT WITH TIES SELECT OBJECTPROPERTY( object_id(''), 'isindexable' ) ( ; WITH , SELECT , COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) (SELECT ) [] [_e2__A9259451] ( ) AS ( SELECT UNION ALL SELECT FROM AS [e2__A9259451-8A3F-4821-A7F0-10C7E3632D25], WHERE ( ) AND ) , ( ) AS ( SELECT * FROM ) , ( ) AS ( SELECT * FROM UNION ) UPDATE Create Table () INSERT INTO VALUES () DELETE FROM DROP CREATE VIEW ( , [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS UNIQUE CLUSTERED INDEX ON ( ) ( ) OPENROWSET ( , ;;, , ) DISTINCT APPROX_COUNT_DISTINCT() AS FROM ( on ) LEFT OUTER JOIN RIGHT OUTER JOIN FULL OUTER JOIN INNER JOIN cross join ( ) cross apply outer apply () AS () GROUP BY ORDER BY WHERE SELECT 1 OPTION ( ) QUERYANNOTATION SELECT 'EngineEdition' AS 'EngineEdition', SERVERPROPERTY('EngineEdition') AS 'EngineEditionServerProperty' OPTION ( ) LABEL = EXEC sys.sp_set_session_context N'client_correlation_id', ''; EXEC sys.sp_set_session_context N'client_correlation_id', NULL; ; HASH JOIN, HASH GROUP SELECT as XLOrdinal, HAS_PERMS_BY_NAME('', 'OBJECT', 'SELECT', '', 'COLUMN') as PermCheckResult SELECT as XLOrdinal, COUNT(*) as RLSPolicyCnt FROM sys.security_predicates WHERE target_object_id = OBJECT_ID('') UNION ALL SELECT sch.name AS schemaname, tbl.name AS tablename, c.name AS columnname FROM sys.masked_columns AS c JOIN sys.tables AS tbl ON c.object_id = tbl.object_id JOIN sys.schemas AS sch ON tbl.schema_id = sch.schema_id WHERE c.is_masked = 1; EXISTS HAVING = ( ) VALUES ( ) SET DATABASE TABLE VIEW INDEX 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_BIG( ) 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 + - / * ( ) ( & ) COALESCE(, 0) COALESCE(, 0) ( | ) ( ^ ) 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') RAND() 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() DATEPART(QUARTER, ) 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. () 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) COALESCE(, 0) COALESCE(, 0) LOG(, ) LEFT RIGHT () COALESCE(, 0) (,) () COALESCE(, 0) REPLICATE(, ) () COALESCE(, '') () COALESCE(, '') (SELECT CASE WHEN DATALENGTH(AuxTable.Op1) = DATALENGTH(AuxTable.Op2) AND AuxTable.Op1 = AuxTable.Op2 COLLATE Latin1_General_Bin THEN 1 ELSE 0 END FROM (SELECT AS Op1, AS Op2) AS AuxTable) CAST( AS nvarchar(4000)) + () (SELECT COALESCE(CAST(AuxTable.Op1 AS nvarchar(4000))+ AuxTable.Op2, AuxTable.Op1) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) (SELECT COALESCE(CAST( AS nvarchar(4000)) + AuxTable.Op2, AuxTable.Op2) FROM (SELECT () AS Op2) as AuxTable) (SELECT COALESCE(CAST(AuxTable.Op1 AS nvarchar(4000))+ AuxTable.Op2, AuxTable.Op1, AuxTable.Op2) FROM (SELECT () AS Op1, () AS Op2) as AuxTable) CHECKSUM() + 4294967296 * COALESCE(, 0) LEFT(, ) RIGHT(, ) REPLICATE(, ) CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') ( + ) (SELECT CASE WHEN DATALENGTH(Op1) = DATALENGTH(Op2) AND Op1 = Op2 COLLATE Latin1_General_Bin THEN 1 ELSE 0 END FROM (SELECT AS Op1, AS Op2) AS AuxTable) () COALESCE(, 0) () COALESCE(, 0) SUBSTRING(,,) REPLACE(, , ) COALESCE(REPLACE(, , ), N'') (SELECT COALESCE(REPLACE(AuxTable.Op1, AuxTable.Op2, COALESCE(AuxTable.Op3, N'')), AuxTable.Op1) FROM (SELECT AS Op1, AS Op2, AS Op3) AS AuxTable) () COALESCE(, N'') () COALESCE(, 0) () COALESCE(, N'') STUFF(, , , ) () COALESCE(, N'') CAST( (SELECT CASE WHEN AuxTable.Result > 0 THEN 1 ELSE AuxTable.Op4 END FROM (SELECT PATINDEX(, SUBSTRING(, , 2097152)) AS Result, as Op4) AS AuxTable) AS bigint) CAST( (SELECT CASE WHEN AuxTable.Result > 0 THEN AuxTable.Result + AuxTable.Op3 - 1 ELSE AuxTable.Op4 END FROM (SELECT PATINDEX(, SUBSTRING(, AuxTable2.Op3, 2097152)) AS Result, AuxTable2.Op3 AS Op3, AuxTable2.Op4 AS Op4 FROM (SELECT AS Op3, as Op4) AS AuxTable2 ) AS AuxTable) AS bigint) SQL90 cartridge error: OpSearch: first parameter is expected to be constant string CAST( AS VARCHAR(64)) COALESCE(, 0) COALESCE(, 0) SUBSTRING(, , ) COALESCE(, '') CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') CHARINDEX(, ) (SELECT CASE WHEN AuxTable.Result > 0 THEN AuxTable.Result ELSE END FROM (SELECT CHARINDEX(, , ) AS Result) AS AuxTable) (SELECT CASE WHEN AuxTable.Result > 0 THEN 1 ELSE END FROM (SELECT PATINDEX('%' + + '%', SUBSTRING(, , 2097152)) AS Result) AS AuxTable) PATINDEX('%' + + '%', ) (SELECT CASE WHEN AuxTable.Result > 0 THEN AuxTable.Result + AuxTable.Op3 - 1 ELSE END FROM (SELECT PATINDEX('%' + + '%', SUBSTRING(, AuxTable2.Op3, 2097152)) AS Result, AuxTable2.Op3 AS Op3 FROM (SELECT AS Op3) AS AuxTable2 ) AS AuxTable) Cartridge error: OpSEARCH/OpPATTERNSEARCH: first parameter is expected to be a constant string CHARINDEX(, COLLATE Latin1_General_CS_AS) (SELECT CASE WHEN AuxTable.Result > 0 THEN AuxTable.Result ELSE END FROM (SELECT CHARINDEX(, COLLATE Latin1_General_CS_AS, ) AS Result) AS AuxTable) CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') CAST( AS VARCHAR(64)) COALESCE(CAST( AS VARCHAR(64)), '') COALESCE(, '') REPLACE(, , ) () 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) CAST(DATEFROMPARTS(, , ) AS DATETIME) DATEADD(DD, -2, CAST(TIMEFROMPARTS(, , , 0, 0) AS DATETIME)) COALESCE(, 0) EOMONTH(, ) DATEADD(mm, , CAST( AS DATE)) YEAR QUARTER MONTH WEEK DAY HOUR MINUTE SECOND DATEDIFF(, , ) COALESCE ( ) IS NULL ( ) nvarchar nvarchar varchar bit tinyint smallint int bigint tinyint smallint int bigint real float datetime datetime money sql_variant uniqueidentifier 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 time) CAST( AS datetime) CAST( AS money) NULL