1. O mais simples é o seguinte
DIMOBJCONN
Setobjconn = server.createObject ("Adobd.Connection")
objconn.openApplication ("Connection_string")
'CallThestoredProcEdureToinCrementAcounterOnThePage
objconn.execute "Execsp_addhit"
Sem parâmetros, sem retorno, sem tratamento de erros, é isso
2. Uma chamada com parâmetros
objconn.execute "Execsp_addhit, 'http: //www.asp001.net',1"
Observe que os parâmetros divididos não são devolvidos aos registros.
3. Retorne ao registro
DIMOBJCONN
DIMOBJRS
Setobjconn = server.createObject ("Adobd.Connection")
Setobjrs = server.createObject ("Adobd.recordset")
objconn.openApplication ("Connection_string")
'CallThestoredProcEdureToinCrementAcounterOnThePage
objrs.openobjconn, "Execsp_listarticles'1/15/2001 '"
'LoopthroughRecordSetAndDisplayEacharticle
4 ....
DIMOBJCONN
DIMOBJCMD
'InstantiateObjects
Setobjconn = server.createObject ("adodb.connection")
setobjcmd = server.createObject ("adodb.command")
Conn.OpenApplication ("Connectionstring")
Combjcmd
.ActiveConnection = Conn'youCanalSoJustSpecifyAconnectionstringHe
.CommandText = "sp_insertarticle"
.CommandType = adcmdStoredProc'ReQuirestHeadevbs.incfileortyPelibMetatag
'AddinputParameters
.Parameters.append.createParameter ("@colunist_id", addouble, adparaminput ,, colunist_id)
.Parameters.append.createParameter ("@url", AdventChar, Adparaminput, 255, URL)
.Parameters.append.createParameter ("@title", AdventChar, Adparaminput, 99, URL)