Question

如何将SQL语句中的表名定义成变量

<%
dim sql,rst,myErrors,asdf
on error resume next
if request.QueryString("act")="add" then
set rst=server.CreateObject("adodb.recordset")
conn.open connstr
asdf=request.Form("f_title")
sql="CREATE TABLE asdf ([id] counter,[a_name] text,[a_time1] integer,[a_time2] integer,[a_time3] integer,[a_time4] integer,[a_time5] integer,[a_time6] integer,[a_time7] integer,[a_time8] integer,[a_time9] integer,[a_time10]integer,[a_time11]integer,[a_time12]integer,[a_time13]integer,[a_time14]integer,[a_time15]integer,[a_time16]integer,[a_time17]integer,[a_time18]integer,[a_time19]integer,[a_time20]integer,[a_total]text,[a_order]text,CONSTRAINT [Index1] PRIMARY KEY ([id]))"
conn.execute(sql)
if myErrors.count=0 then
msgboxU "表添加成功<"&request.Form("f_title")&">成功!"
else
msgboxU "表添加失败! 原因："&myErrors.item(0).description
end if
end if
rst.close
%>

Answer 1

sql="CREATE TABLE '&asdf&' ([id] counter,[a_name] text,[a_time1] integer,[a_time2] integer,[a_time3] integer,[a_time4] integer,[a_time5] integer,[a_time6] integer,[a_time7] integer,[a_time8] integer,[a_time9] integer,[a_time10]integer,[a_time11]integer,[a_time12]integer,[a_time13]integer,[a_time14]integer,[a_time15]integer,[a_time16]integer,[a_time17]integer,[a_time18]integer,[a_time19]integer,[a_time20]integer,[a_total]text,[a_order]text,CONSTRAINT [Index1] PRIMARY KEY ([id]))"

Answer 2

如何将sql语句中的表名定义成变量
oniaobi享溪网浇仆陵占垫报拖