以vb为例:
dim sql as string
sql="create table " & tablename & " (Id int"
for i =1 to fieldcount
sql=sql & "," namearray(i) & "numeric(10,2)"
next
sql=sql & ")"con.execute sql
dim sql as string
sql="create table " & tablename & " (Id int"
for i =1 to fieldcount
sql=sql & "," namearray(i) & "numeric(10,2)"
next
sql=sql & ")"con.execute sql
在SQL Server中如何实现通过变量新建表?
谢谢!
我已经得到一个字串@y0='a1'或等于其他,下面
set @y1='create table y1 ('+@y0+' int,a2 int)'
然后如何执行@y1字串中的语句呢?
谢谢!