IT分销/经销
原来用这个一直能编译通过RIGHT，今天突然提示没有这个函数
DECLARE v_Date TIMESTAMP;
SET v_Date = '2012-11-01-12.12.12.000000';
SET v_t_name = 'MYHOMEWORK' || MSSQL.RIGHT(CAST (CHAR(YEAR(v_Date)) AS CHAR(4)), 2) || MSSQL.RIGHT(CAST (CHAR(MONTH(v_Date) + 100) AS CHAR(3)), 2);
SET v_Date = '2012-11-01-12.12.12.000000';
SET v_t_name = 'MYHOMEWORK' || MSSQL.RIGHT(CAST (CHAR(YEAR(v_Date)) AS CHAR(4)), 2) || MSSQL.RIGHT(CAST (CHAR(MONTH(v_Date) + 100) AS CHAR(3)), 2);
5同行回答
去掉也不正常,那个是ibm转换工具转换后自动生成的,前面那些编译通过的存储过程也是带MSSQL的,都能编译通过收起
浏览679
是db2 的 用ibm的数据库迁移工具时自动转换生成的,我前面的31个存储过程都编译通过了,就有一个怎么编译都提示找不到这个函数,郁闷,我知道用substr也能实现我想要的结果,可是不明白其中的问题出在哪?收起
浏览677
Many Peuterey Jackets online can give you the charming and the confident appearance in the leisure and the fashion occasions.So how can you refuse the Peuterey Jackets from the Peuterey Outlet online shop.收起
浏览638