create proc 过程名
@类别名
as
exec('create table '+@类别名+'(devicename varchar(100),status varchar(100))')
@类别名
as
exec('create table '+@类别名+'(devicename varchar(100),status varchar(100))')
调试欢乐多
@类别名 varchar(100)
as
exec('create table '+@类别名+'(devicename varchar(100),status varchar(100))')
<!--#include file="conn.asp"-->
<%create proc guocheng1
@leibie1 varchar(100)
as
exec('create table '+@leibie1+'(devicename varchar(100),status varchar(100))')%>
则执行第二行时出错,另外,最后一行后半部分被注释掉了啊
<!--#include file="conn.asp"-->
<%sql="create table aaa (devicename varchar(100),status varchar(100))"
conn.exec sql
%>
这么说,动态增加新表是不是一定要存储过程?
ok,我做了一个存储过程,
create proc addleibie
@leibiename varchar(100)
as
exec('create table '+@leibiename+'(devicename varchar(100),status varchar(100))')
这个已经做好了。然后我调用存储过程,
<!--#include file="conn.asp"-->
<%
set cm=server.CreateObject("adodb.command")
set cm.ActiveConnection=conn
cm.CommandText="addleibie"
cm.CommandType =adCmdStoredProc
set param=cm.CreateParameter("@leibiename",adVarChar,adParamInput,10)
cm.Parameters.append param
cm("@leibiename")="leibie1"
set rst=cm.Execute
%>
错误在"cm.CommandType =adCmdStoredProc"这一行
错误提示“Procedure 'addleibie' expects parameter '@leibiename', which was not supplied”