27,579
社区成员
发帖
与我相关
我的任务
分享
ALTER PROCEDURE [dbo].[updateCjxm]
AS
BEGIN
DECLARE @name VARCHAR(200)
DECLARE @bzz VARCHAR(200)
DECLARE @jcz VARCHAR(100)
DECLARE @iguid VARCHAR(200)
DECLARE @str VARCHAR(5000)
DECLARE cjxmjg CURSOR FOR
--这个里面有数据?
SELECT [name],bzz,jcz,iguid FROM 抽检项目录入 WHERE b271='不合格'
OPEN cjxmjg
FETCH NEXT FROM cjxmjg INTO @name,@bzz,@jcz,@iguid
WHILE @@FETCH_STATUS = 0
BEGIN
SET @str = @name + ':' + @bzz + '/' + @jcz ;
PRINT @str
BEGIN
UPDATE 抽查结果信息表录入
SET b28 = @str
WHERE iguid = @iguid
END
FETCH NEXT FROM cjxmjg INTO @name,@bzz,@jcz,@iguid
END
CLOSE cjxmjg
DEALLOCATE cjxmjg
END