asp中sql语句

1.执行存储过程

    (1)存储过程中应该使用set nocount on

    (2)

    rs.close
    set rs=nothing
    set rs=CreateObject("ADODB.DataSet")
    set objCmd1=nothing
    set objCmd1=CreateObject("ADODB.Command")
    Set objCmd1.ActiveConnection=Conn
    objCmd1.CommandText="SP_XWQ_GetVoteTitle"
    objCmd1.CommandType=4
    objCmd1.prepared=true
    objCmd1.Parameters.Append objCmd1.CreateParameter("@orderSN",adinteger,adparaminput)
    objCmd1("@orderSN")=tmpOrderSN
    objCmd1.Parameters.Append objCmd1.CreateParameter("@VEIID",adinteger,adparaminput)
    objCmd1("@VEIID")=rsHotel("COLD_ServiceSN")
    set rs=objCmd1.Execute

2.循环执行sql语句

    必须先释放掉现在的资源，再次创建，如上面执行存储过程