insert into sqltable@sql2000 select add_months(workdate,3) from oracletable
报错数据库sql2000不支持此上下文中的add_months
请问怎样能使用oracle中的函数??
注:链接没问题 select 很正常,去除add_months也能正常插入
报错数据库sql2000不支持此上下文中的add_months
请问怎样能使用oracle中的函数??
注:链接没问题 select 很正常,去除add_months也能正常插入
* Comparison Operators
* Pattern Matching
* Group Functions
* String Functions
* Other FunctionsB.2.2.1 Arithmetic Operators
Oracle Microsoft SQL Server
+
+
- -
*
*
/
/B.2.2.2 Comparison Operators
Oracle Microsoft SQL Server
=
=
> >
<
<
>= >=
<=
<=
<>, !=, ^= <>
IS NOT NULL IS NOT NULL
IS NULL IS NULLB.2.2.3 Pattern Matching
Oracle Microsoft SQL Server
LIKE LIKE
NOT LIKE NOT LIKEB.2.2.4 Group Functions
Oracle Microsoft SQL Server
AVG AVG
COUNT COUNT
MAX MAX
MIN MIN
SUM SUMB.2.2.5 String Functions
Oracle Microsoft SQL Server
||, CONCAT + (expression1 + expression2)
ASCII ASCII
CHR CHAR
INSTR (with two arguments) CHARINDEX
LENGTH DATALENGTH
LOWER LOWER
LTRIM LTRIM
RTRIM RTRIM
SUBSTR (second argument cannot be a negative number) SUBSTRING
UPPER UPPERB.2.2.6 Other Functions
Oracle Microsoft SQL Server
ABS ABS
CEIL CEILING
COS COS
EXP EXP
FLOOR FLOOR
LN LOG
LOG LOG10
MOD %
NOT NVL IS NOT NULL
NVL IS NULL
POWER POWER
ROUND ROUND
SIN SIN
SQRT SQRT
TAN TAN
:(