1、最简单的如下 Dim objConn Set objConn = Server.CreateObject("ADOBD.Connection") objConn.Open Application("Connection_String") 'Call the stored procedure to increment a counter on the page objConn.Execute "exec sp_AddHit" 没有参数，没有返回，没有错误处理，就是这个了
3、返回记录的 Dim objConn Dim objRs Set objConn = Server.CreateObject("ADOBD.Connection") Set objRs = Server.CreateObject("ADOBD.Recordset") objConn.Open Application("Connection_String") 'Call the stored procedure to increment a counter on the page objRs.Open objConn, "exec sp_ListArticles '1/15/2001'" 'Loop through recordset and display each article 4、…… Dim objConn Dim objCmd
'Instantiate objects Set objConn = Server.CreateObject("ADODB.Connection") set objCmd = Server.CreateObject("ADODB.Command") conn.Open Application("ConnectionString")
With objCmd .ActiveConnection = conn 'You can also just specify a connection string here .CommandText = "sp_InsertArticle" .CommandType = adCmdStoredProc 'Requires the adovbs.inc file or typelib meta tag
'Execute the function 'If not returning a recordset, use the adExecuteNoRecords parameter option .Execute, , adExecuteNoRecords link_id = .Parameters("@link_id") End With
5、存储过程的代码 Create PROCEDURE dbo.sp_InsertArticle ( @columnist_id int, @url varchar(255), @title varchar(99), @description text @link_id int OUTPUT ) AS BEGIN INSERT INTO dbo.t_link (columnist_id,url,title,description) VALUES (@columnist_id,@url,@title,@description)
