不好意思输入错了 UPDATE DEPTOUN SET IDNO=NOTEIDNO,IDRATING=LEN(NOTEIDNO)/3 FROM (SELECT NOTENO,NOTEIDNO FROM NOTELIST) WHERE DEPTNO=NOTENO noteno从(SELECT NOTENO,NOTEIDNO FROM NOTELIST)这里获取的
declare @V_NOTENO 类型 declare @V_NOTEIDNO 类型 SELECT @V_NOTENO=NOTENO,@V_NOTEIDNO=NOTEIDNO FROM NOTELIST UPDATE DEPTOUN SET IDNO=@V_NOTEIDNO,IDRATING=LEN(@V_NOTEIDNO)/3 FROM 表名 WHERE DEPTNO=@V_NOTENO这个是不是你要的?你的代码看起来的确满吃力...
UPDATE DEPTOUN SET IDNO=NOTEIDNO,IDRATING=LEN(NOTEIDNO)/3 FROM (SELECT NOTENO,NOTEIDNO FROM NOTELIST) WHERE DEPTNO=NOTENO
noteno从(SELECT NOTENO,NOTEIDNO FROM NOTELIST)这里获取的
declare @V_NOTEIDNO 类型
SELECT @V_NOTENO=NOTENO,@V_NOTEIDNO=NOTEIDNO FROM NOTELIST
UPDATE DEPTOUN SET IDNO=@V_NOTEIDNO,IDRATING=LEN(@V_NOTEIDNO)/3 FROM 表名 WHERE DEPTNO=@V_NOTENO这个是不是你要的?你的代码看起来的确满吃力...