FOR I=1 TO N
SQL=“INSERT INTO TABLE (ID,DATA) VALUE (" & I & "," & DATA(I) & ")"
execute(sql)
NEXT
SQL=“INSERT INTO TABLE (ID,DATA) VALUE (" & I & "," & DATA(I) & ")"
execute(sql)
NEXT
调试欢乐多
declare @sql char(50)set @i=1
while @i<=@N
begin
set @SQL='INSERT INTO TABLE (ID,DATA) VALUE (' +@i + ',' + sin(@i) + ')'
execute @sql
end