转换脚本(Oracle 10g到MSSQL 2005) [英] Convert script(Oracle 10g to MSSQL 2005)

问题描述

亲爱的，
请帮助我摆脱这个问题.

Dear,
Please help me to get out from this problem.

FUNCTION Get_New_DISTRIBUTERID (a IN NUMBER)
   RETURN VARCHAR2
IS
   tmp_id   SM_DIVIDEND_BONUSDISTRIBUTER.DIVIDEND_DISTRIBUTER_ID%TYPE;
BEGIN
   SELECT   NVL (MAX (DIVIDEND_DISTRIBUTER_ID), TO_CHAR (SYSDATE, 'yymmdd') || '000000000000')
     INTO   tmp_id
     FROM   SM_DIVIDEND_BONUSDISTRIBUTER;

   IF SUBSTR (tmp_id, 1, 6) = TO_CHAR (SYSDATE, 'yymmdd')
   THEN
      RETURN TO_CHAR (tmp_id + 1, '000000000000000000');
   ELSE
      RETURN TO_CHAR (SYSDATE, 'yymmdd') || '000000000001';
   END IF;
END;

我需要在sql server 2005中进行转换，可以在sql函数或过程中进行转换.

在此先感谢
Mahmud

i need to convert in sql server 2005,it can be in sql function or procedure.

thanks in advance
Mahmud

推荐答案

此在线工具可以为您提供帮助

这篇关于转换脚本(Oracle 10g到MSSQL 2005)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！