maxProjectID



SELECT LPAD(NVL(max(substr(D_PROJECT.PROJECTID,11,18)),0)+1,7,’0′) as maxProID
    FROM d_project


SELECT RIGHT(’0000′ + CONVERT(varchar, ISNULL(MAX(COMPUTERID), 0) + 1), 3)
FROM S_COMPUTER

INSERT INTO S_COMPUTER
      (COMPUTERID, COMPUTERNAME, IP)
SELECT (SELECT RIGHT(’0000′ + CONVERT(varchar, ISNULL(MAX(COMPUTERID), 0) + 1), 3)
          FROM S_COMPUTER) , ‘lqh-home’ , ’127.0.0.1′



Trackback URL | Say something...