代码如下:
Dim objCon
Set objCon = Server.CreateObject("ADODB.Connection")
objCon.Open = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=school;Data Source=TY-SORCERER"
strSQL = "insert into student (id,class_id,number,name,uuid,password) values ('1','1','1','小王','1','1') "
objCon.Execute (strSQL)
我想望数据库中添加一条记录,可是总说运行时错误。各位大哥来救小弟了
---------------------------------------------------------------
what error did you get? try to run the SQL statement in Query Analyzer