FILE: C:\Program Files (x86)\Microsoft Analysis Services\AS OLEDB\110\Cartridges\sql90.xsl
--
yes
[
]
N'
'
Microsoft SQL Server.09
Microsoft SQL Server.10
Microsoft SQL Server.11
Microsoft SQL Server.12
Microsoft SQL Server.13
TABLOCK,FIRE_TRIGGERS
1
2
16
64
64
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
Microsoft.DataWarehouse.Controls.SqlClientQueryDesigner, Microsoft.DataWarehouse
System.Data.OleDb
Microsoft.DataWarehouse.Design.OleDbSchema, Microsoft.DataWarehouse
Microsoft.DataWarehouse.Controls.OleDbQueryDesigner, Microsoft.DataWarehouse
System.Data.Odbc
Microsoft.DataWarehouse.Design.OdbcSchema, Microsoft.DataWarehouse
auto
yes
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
INSERT INTO
DELETE FROM
DROP
CREATE
VIEW ( , [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS
UNIQUE CLUSTERED INDEX ON ( )
( )
OPENROWSET
(
,
;;,
,
)
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
=
(
)
VALUES
(
)
SET
DATABASE
TABLE
VIEW
INDEX
null
primary key
(
)
ISNULL(, CAST(-2 AS datetime))
ISNULL(, 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
+
-
/
*
(
)
LOWER()
UPPER()
LEN()
LTRIM()
RTRIM()
RTRIM(LTRIM())
NOT()
CAST((CASE WHEN () THEN 0 ELSE 1 END) AS BIT)
1 - ()
ISNULL(1 - (), 1)
-()
ABS
CEILING
FLOOR
SIGN
SQRT
SQUARE
()
EXP
LOG
LOG10
()
(ISNULL((), 0))
(CASE WHEN COUNT_BIG( ) = 0 THEN NULL ELSE COUNT_BIG( ) END)
(CASE WHEN (COUNT_BIG(DISTINCT ) + MAX(CASE WHEN IS NULL THEN 1 ELSE 0 END)) = 0 THEN NULL
ELSE (COUNT_BIG(DISTINCT ) + MAX(CASE WHEN IS NULL THEN 1 ELSE 0 END)) END)
(CASE WHEN COUNT_BIG(DISTINCT ) = 0 THEN NULL
ELSE COUNT_BIG(DISTINCT ) END)
>
<
<>
=
>=
<=
()
ISNULL(, '')
ISNULL(, CAST(-2 AS datetime))
ISNULL(, 0)
()
ISNULL(, '')
ISNULL(, CAST(-2 AS datetime))
ISNULL(, 0)
() = ()
() = () 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
() + ()
(SELECT ISNULL(AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1) FROM (SELECT AS Op1, AS Op2) as AuxTable)
(SELECT ISNULL(() + AuxTable.Op2, AuxTable.Op2) FROM (SELECT AS Op2) as AuxTable)
(SELECT COALESCE(AuxTable.Op1 + CAST(AuxTable.Op2 + 2 AS float) , AuxTable.Op1, AuxTable.Op2) FROM (SELECT AS Op1, () AS Op2) as AuxTable)
(SELECT COALESCE(AuxTable.Op1 + AuxTable.Op2, AuxTable.Op1, AuxTable.Op2) FROM (SELECT AS Op1, AS Op2) as AuxTable)
() - ()
(SELECT ISNULL(AuxTable.Op1 - AuxTable.Op2, AuxTable.Op1) FROM (SELECT AS Op1, AS Op2) as AuxTable)
(SELECT ISNULL(() - AuxTable.Op2, -AuxTable.Op2) FROM (SELECT AS Op2) as AuxTable)
(SELECT COALESCE(AuxTable.Op1 - AuxTable.Op2, AuxTable.Op1, -AuxTable.Op2) FROM (SELECT () AS Op1, AS Op2) as AuxTable)
() / ()
() / ISNULL(, 0)
() *
(
)
CAST(() * () AS money)
() * ()
(SELECT
CASE
WHEN AuxTable.Op1 IS NULL
THEN NULL
ELSE
CASE
WHEN AuxTable.Op2 IS NULL OR AuxTable.Op2 = 0
THEN AuxTable.Op3
ELSE
AuxTable.Op1 / AuxTable.Op2
END
END
FROM (SELECT
() AS Op1,
() AS Op2,
() AS Op3
) as AuxTable
)
OR
AND
() ()
ROUND((), ())
ROUND((), ISNULL((), 0))
ROUND((), (), 1)
ROUND((), ISNULL((), 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, ISNULL((), 0) AS Op2) AS AuxTable)
ROUND(() / (), 0, 1)
ROUND(() / ISNULL((), 0), 0, 1)
(LOG() / LOG())
(LOG() / LOG(ISNULL((), 0)))
(LOG(ISNULL((), 0)) / LOG())
(LOG(ISNULL((), 0)) / LOG(ISNULL((), 0)))
POWER((), ())
POWER((), ISNULL((), 0))
ISNULL((), ())
() % ()
(() / ())
(() / ISNULL((), 0))
(ISNULL((), 0) / ())
(ISNULL((), 0) / ISNULL((), 0))
Op1
(ISNULL(Op1, 0))
Op2
(ISNULL(Op2, 0))
(SELECT CASE WHEN < THEN Op1 ELSE Op2 END FROM (SELECT () AS Op1, () AS Op2) AS AuxTable)
Op1
(ISNULL(Op1, 0))
Op2
(ISNULL(Op2, 0))
(SELECT CASE WHEN > THEN Op1 ELSE Op2 END FROM (SELECT () AS Op1, () AS Op2) AS AuxTable)
LEFT
RIGHT
()
ISNULL(, 0)
(,)
()
ISNULL(, 0)
REPLICATE(, )
()
ISNULL(, '')
()
ISNULL(, '')
(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(max)) + ()
(SELECT ISNULL(CAST(AuxTable.Op1 AS nvarchar(max))+ AuxTable.Op2, AuxTable.Op1) FROM (SELECT () AS Op1, () AS Op2) as AuxTable)
(SELECT ISNULL(CAST( AS nvarchar(max)) + AuxTable.Op2, AuxTable.Op2) FROM (SELECT () AS Op2) as AuxTable)
(SELECT COALESCE(CAST(AuxTable.Op1 AS nvarchar(max))+ AuxTable.Op2, AuxTable.Op1, AuxTable.Op2) FROM (SELECT () AS Op1, () AS Op2) as AuxTable)
()
ISNULL(, 0)
()
ISNULL(, 0)
SUBSTRING(,,)
REPLACE(, , )
ISNULL(REPLACE(, , ), N'')
(SELECT ISNULL(REPLACE(AuxTable.Op1, AuxTable.Op2, ISNULL(AuxTable.Op3, N'')), AuxTable.Op1)
FROM (SELECT AS Op1, AS Op2, AS Op3) AS AuxTable)
()
ISNULL(, N'')
()
ISNULL(, 0)
()
ISNULL(, N'')
STUFF(, ,
, )
()
ISNULL(, 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
()
ISNULL(, 0)
()
ISNULL(, 0)
()
ISNULL(, 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)
()
ISNULL(, CAST(-2 AS datetime))
()
ISNULL(, 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)
()
ISNULL(, 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
(
)
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
CAST(1 AS BIT)
1=0
CAST(0 AS BIT)
( )
(
, )
CAST( AS )
CAST(() + 2 AS float)
CAST(CASE WHEN THEN 1 ELSE 0 END AS float)
CAST( AS float)
(SELECT CAST(AuxTable.Op1 + CASE WHEN AuxTable.Op1 < 0 THEN -0.5 ELSE 0.5 END AS bigint)
FROM (SELECT CAST( AS float) + 2 AS Op1) as AuxTable)
(SELECT CAST(AuxTable.Op1 + CASE WHEN AuxTable.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( as bigint)
CAST( AS money) + 2
CAST(CASE WHEN THEN 1 ELSE 0 END 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 N'TRUE' ELSE N'FALSE' END
CASE WHEN THEN N'TRUE' ELSE N'FALSE' END
CAST( AS nvarchar(max))
SQL90 cartridge error: OpCast: ResultType is not specified
CASE
END
WHEN ()
THEN ()
ELSE ()
RANK()
DENSE_RANK()
ROW_NUMBER()
NTILE()
OVER
(
)
PARTITION BY
CAST( AS bit)
CAST( AS datetime)
CAST( AS datetime)
CAST( AS money)
NULL
--