for循环没有执行

[fa791222]

num=2

sql &= strUnion
for i=i to num
sql &= "select 2+i*3,6+i*3"
sql &= " from A"
next
strUnion = " union "
为什么出现的结果是 select 2+i*3,6+i*3 from A union select 2+i*3,6+i*3 from A
而不是我想要的结果 5 9
7 12
哪为大虾指点下,先谢了

[acewang]

"select 2+i*3,6+i*3"
~~
在这是字符串，不是变量

[wwl1981]

那个是字符串如下写
num=2

sql &= strUnion
sql ="select "
for i=i to num
sql &= 2+i*3&","&6+i*3
next
sql &= " from A"
strUnion = " union "

[sjc0]

这样用对吗？
sql &= strUnion
for i=i to num
sql &= "select 2+i*3,6+i*3"
sql &= " from A"
next
strUnion = " union "
////
sql &= strUnion
for i=i to num
sql &= "select "&2+i*3&","&6+i*3&"
sql &= " from A"
next
strUnion = " union "

[yistudio]

for i=i to num
sql &= "select 2+i*3,6+i*3"
sql &= " from A"
next
改为
for i=i to num
sql &= "select " & 2+i*3 & "," & 6+i*3
sql &= " from A"
next

[火电]

如果是存储过程
可以 用
create procedure aaa
@i
as
declare @aa int
declare @bb int
select @aa = @i*3
select @bb = @i*2

在把变量带入sql语句中
return(0)