yes
[
]
N'
'
SQL Server
ASE Server
10
85
85
-1
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
)
UPDATE
INSERT INTO
DELETE FROM
DROP
CREATE
( )
DISTINCT
AS
FROM
GROUP BY
ORDER BY
WHERE
HAVING
=
(
)
VALUES
(
)
SET
DATABASE
TABLE
VIEW
primary key
(
)
ASC
DESC
@
?
DATEPART( , )
year
quarter
month
dayofyear
day
week
weekday
hour
minute
second
millisecond
*
MIN
MAX
SUM
( )
COUNT_BIG ( )
=
<>
>
>=
<
<=
IN
AND
OR
+
-
/
*
(
)
IS NULL
(
)
nvarchar
univarchar
varchar
bit
tinyint
smallint
int
bigint
tinyint
unsigned smallint
unsigned int
unsigned bigint
real
float
datetime
datetime
money
varbinary
varchar
varbinary
decimal
( )
(
, )
CAST( AS )
CAST( AS bit)
CAST( AS datetime)
CAST( AS datetime)
CAST( AS money)