asp sql语句

conn.execute("Insert into MemberRelation(username,secuser,relation)
values('"&request.cookies("name")&"','"&secuser&"',"&group_id_cp&")")

sql3="Insert into MemberRelation(username,secuser,relation)
values('"&request.cookies("name")&"','"&rs("username")&"',"&relation&")"
conn.execute(sql3)

sql3="Insert into MemberRelation(username,secuser,relation)
values('"&request.cookies("name")&"','"&rs("username")&"',"&relation&")"
conn.execute(sql3)
friendsql="insert into TB_FriendEmployee values("&tempid&","&tempid&",1)"
tempconn.execute friendsql

set tempconn=Server.CreateObject("adodb.connection")
tempconn.connectionstring="driver={sql
server};server=192.168.0.22;uid=sa;pwd=;database=HantTalk;"
tempconn.open

tempsql="insert into vo_userinfor
values('"&name1&"',0,'"&pass&"','"&user&"',1,null,'"&ch&"','"&phone&"','"&mobile&"','"&qymc&"','"&p_z_Z_productionService&"','"&email&"','','"&address&"','','"&post&"','','','',1,'','0',null,null,null,0,0)"
tempconn.execute tempsql

查询 更新 添加 删除 都可以用recordset
更新
update
rs.open sql,conn,1,3
rs(" ")=
rs.update
删除
Set RS1=Server.Createobject("adodb.recordset")
Sql1="Delete From banner where linkid="&request("linkid")
Rs1.open sql1,conn,1,1
Rs1.close
Set rs1=nothing

不用创建纪录集
sql="select * from exhibition where id="&id&" and flag=1"
set rs=conn.execute(sql)
不用创建纪录集

conn.execute("sql语句")
conn.execute sql
conn.execute(delsql)

rs.recordcount

转载于:https://www.cnblogs.com/hnxc345/archive/2011/12/16/2289686.html