向远程表插入数据的问题!
用inster 表名(字段) values(值)向过程 表插入数据,由于 字段太多,字符超过255个提示错误,怎么解决呀!用inster 表名 from 数组 行不?怎么用?我试了试总是不行。
我用第一种方法要是字段少了可以,字段太多就不行了。求求了急
Text to GetSql NoShow Pretext 7 TEXTMERGE select *,CAST(0 as float) as cj1,CAST(0 as float) as cj2,CAST(0 as float) as cj3,CAST(0 as float) as cj4,CAST(0 as varchar(60)) as km,CAST(0 as varchar(20)) as lb, CAST(0 as varchar(20)) as lx,CAST(0 as varchar(20)) as js from Enrolldata where grade=?aa EndText EXECSCRIPT(GetSql)对超长字符串同样有效