yes
"
"
'
'
DB2/NT.08.01.0000
DB2
29
29
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
(
)
(
)
SELECT OBJECTPROPERTY( object_id(''), 'isindexable' )
(
SELECT
, COUNT_BIG(*) AS [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a]
)
UPDATE
INSERT INTO
DELETE FROM
DROP
CREATE
VIEW ( , [COUNT_BIG_7673aff6-2445-4ef6-a4c9-7bf3d93bd42a] ) WITH SCHEMABINDING AS
UNIQUE CLUSTERED INDEX ON ( )
( )
DISTINCT
AS
FROM
GROUP BY
ORDER BY
WHERE
HAVING
=
(
)
VALUES
(
)
SET
DATABASE
TABLE
VIEW
INDEX
primary key
(
)
ASC
DESC
@
?
( )
year
quarter
month
dayofyear
day
week
dayofweek
hour
minute
second
microsecond
*
MIN
MAX
SUM
( )
COUNT_BIG ( )
=
<>
>
>=
<
<=
IN
AND
OR
+
-
/
*
(
)
IS NULL
(
)
varchar
varchar
char
smallint
smallint
smallint
integer
bigint
smallint
smallint
integer
bigint
real
float
timestamp
timestamp
double
varchar() for bit data
varchar
varchar() for bit data
decimal
( )
(
, )
CAST( AS )
CAST( AS bit)
CAST( AS timestamp)
CAST( AS timestamp)
CAST( AS money)