Rumah > Artikel > pangkalan data > asp mssql向数据库中保存信息
' mssql向中保存信息
Set conn = Server.CreateObject("ADODB.Connection")
strconn="Provider=SQLOLEDB.1;Persist Sercurity Info=True;User ID=sa;PWD=sa;Initial Catalog=database;Data Source=(127.0.0.1)"
conn.open strconn
sql ="insert into datab(url)values('www.111cn.net')";
conn.execute( sql )
response.Write("保存成功")