为什么我写的带循环的存储过程却不执行循环呢？只执行一句就结束了

2006-10-31 05:02:15 189 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

JS 解决冒泡事件冒泡事件冒泡事件就是说它会一层一层的传递上去,比如说: 你给div和它的子元素同时添加了点击事件,那么你点击子元素作为它的父元素的div的点击也会同时触发,解决这种问题的方法如下: <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta nam... 阅读详情

SET @i = 1;
WHILE (@i <= @@rowcount)
BEGIN
UPDATE @EXHI_INDUSTRY
SET [ex_id] = (SELECT TOP 1 [ex_id]
FROM [cnexpo_exhibition]
WHERE [ex_industry] = (SELECT [industry_code]
FROM @EXHI_INDUSTRY
WHERE [Row_ID] = @i)),
[ex_name] = (SELECT TOP 1 [ex_name]
FROM [cnexpo_exhibition]
WHERE [ex_industry] = (SELECT [industry_code]
FROM @EXHI_INDUSTRY
WHERE [Row_ID] = @i))
WHERE [ROW_ID] = @i

SET @i = @i + 1
IF @i > @@rowcount
BREAK
END

这种格式应该没有错误吧？谁能指点一下？

...全文