|
1. Calling SQL Server stored
procedure
Calling SQL Server stored procedure without parameters:
|
dbConnection.Execute "EXEC StoredProcNameHere"
|
Passing one of field values as a parameter:
|
dbConnection.Execute "EXEC StoredProcNameHere '"
&
values("FieldName") & "'"
|
2. Executing MS Access
query
Executing MS Access query without parameters:
|
Set cmd = Server.CreateObject ("ADODB.Command")
cmd.ActiveConnection = dbConnection
cmd.CommandText = "MyQueryNameHere"
cmd.CommandType = 4 ' adCmdStoredProc
cmd.Execute
|
Passing one of field values as a parameter:
|
Set cmd = Server.CreateObject ("ADODB.Command")
cmd.ActiveConnection = dbConnection
cmd.CommandText = "MyQueryNameHere '" &
values("FieldName") & "'"
cmd.CommandType = 4 '
adCmdStoredProc
cmd.Execute
|
|
