因为做数据库维护,很多原先并不知道的东东一点点浮现出来,ESCAPE SEQUENCE是修bug的时候发现的一类功能。
MS ODBC定义里有以下几种:
-Date, Time, and Timestamp Escape Sequences
-GUID Escape Sequences
-Interval Escape Sequences
-LIKE Escape Sequence
-Outer Join Escape Sequence
-Procedure Call Escape Sequence
-Scalar Function Escape Sequence
而我们的产品Symfoware支持相对少一点,但是优点是对日文的支持(我猜的,^_^)。
-Date, Time, and Timestamp Escape SequencesDATE型
INSERT INTO S1.T3 (C1,C3) VALUES('あああ',{d '1997-12-10'})
-Date, Time, and Timestamp Escape SequencesTIME型
INSERT INTO S1.T3 (C1,C2) VALUES('あああ',{t '12:15:00'})
-Date, Time, and Timestamp Escape SequencesTIMESTAMP型
INSERT INTO S1.T3 (C1,C4) VALUES('あああ',{ts '1997-12-10 12:15:00'})
-Interval Escape Sequences
INSERT INTO S1.T3 (C1,C4) VALUES('あああ',{ts '1997-12-10 12:15:00'}) /*插入测试数据*/
SELECT C4+ {INTERVAL +'10' DAY} FROM S1.T3
-LIKE Escape Sequence
INSERT INTO S1.T1(C1,C2) VALUES('あああ','%aaa')
SELECT C1 FROM S1.T1 WHERE C1 LIKE 'あああ' AND C2 LIKE '*%%' {escape '*'}
/*转义。因为LIKE语句后面的%是通配符,只有在添加转义字符说明后才能被识别为真正的'%'*/
-Procedure Call Escape Sequence
{call proc(param1, param2)}与call proc(param1, param2)语句效果实际上是一样的
-Outer Join Escape Sequence
SELECT S1.T1.C1,S1.T2.C2 FROM {oj S1.T1 LEFT OUTER JOIN S1.T2 ON S1.T1.C1=S1.T1.C1}")
MS ODBC定义里有以下几种:
-Date, Time, and Timestamp Escape Sequences
-GUID Escape Sequences
-Interval Escape Sequences
-LIKE Escape Sequence
-Outer Join Escape Sequence
-Procedure Call Escape Sequence
-Scalar Function Escape Sequence
而我们的产品Symfoware支持相对少一点,但是优点是对日文的支持(我猜的,^_^)。
-Date, Time, and Timestamp Escape SequencesDATE型
INSERT INTO S1.T3 (C1,C3) VALUES('あああ',{d '1997-12-10'})
-Date, Time, and Timestamp Escape SequencesTIME型
INSERT INTO S1.T3 (C1,C2) VALUES('あああ',{t '12:15:00'})
-Date, Time, and Timestamp Escape SequencesTIMESTAMP型
INSERT INTO S1.T3 (C1,C4) VALUES('あああ',{ts '1997-12-10 12:15:00'})
-Interval Escape Sequences
INSERT INTO S1.T3 (C1,C4) VALUES('あああ',{ts '1997-12-10 12:15:00'}) /*插入测试数据*/
SELECT C4+ {INTERVAL +'10' DAY} FROM S1.T3
-LIKE Escape Sequence
INSERT INTO S1.T1(C1,C2) VALUES('あああ','%aaa')
SELECT C1 FROM S1.T1 WHERE C1 LIKE 'あああ' AND C2 LIKE '*%%' {escape '*'}
/*转义。因为LIKE语句后面的%是通配符,只有在添加转义字符说明后才能被识别为真正的'%'*/
-Procedure Call Escape Sequence
{call proc(param1, param2)}与call proc(param1, param2)语句效果实际上是一样的
-Outer Join Escape Sequence
SELECT S1.T1.C1,S1.T2.C2 FROM {oj S1.T1 LEFT OUTER JOIN S1.T2 ON S1.T1.C1=S1.T1.C1}")