Sql = "SELECT ID,TeacherID,IP,sign,schoolID FROM [DanweiOARe] WHERE ID=" & ID查询是否有记录
如何 没有记录,存执行插入一条记录,带参数
conn.execute("INSERT INTO [DanweiOARe](id,teacherid,SchoolID,ip) VALUES("&id&","&teacherid&","&SchoolID&",'"&Request.ServerVariables("REMOTE_ADDR")&"')")
求用asp+sql2000求存储过程写法
如何 没有记录,存执行插入一条记录,带参数
conn.execute("INSERT INTO [DanweiOARe](id,teacherid,SchoolID,ip) VALUES("&id&","&teacherid&","&SchoolID&",'"&Request.ServerVariables("REMOTE_ADDR")&"')")
求用asp+sql2000求存储过程写法
Sql = sql & " begin INSERT INTO [DanweiOARe](id,teacherid,SchoolID,ip) VALUES("&id&","&teacherid&","&SchoolID&",'"&Request.ServerVariables("REMOTE_ADDR")&"') end")