asp mssql向數據庫中保存信息

ASP教程 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.update8.com)";
conn.execute( sql )
response.Write("保存成功"）