Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I call a stored procedure in SQL server from ASP

Status
Not open for further replies.
didojove

didojove

Technical User
Jan 25, 2002
3
PH
Sorry, Im new on this.

After setting the database connection to an SQL server, what's the command for calling a stored procedure (named, let's say "crosstabs")?

thank you.
 
Sort by date Sort by votes
dim comObj
set comObj = server.createObject("ADODB.Command")
comObj.activeConnection = connection
comObj.commandType = 4 'adCmdStoredProcedure
comObj.commandText = "crosstabs"

comObj.parameters("@param1").value = value1
comObj.parameters("@param2").value = value2

comObj.execute

:)
paul
penny.gif
penny.gif
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
496
leifoet
leifoet
leifoet
  • Locked
  • Question
Code does not run in Microsoft Edge - it does in Google Chrome
Replies
3
Views
702
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
write HTML code within ASP line
Replies
1
Views
510
xwb
xwb
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
421
penguinspeaks
penguinspeaks
leifoet
  • Locked
  • Question
How to check if a datatable is empty ?
Replies
0
Views
382
leifoet
leifoet

Part and Inventory Search

Sponsor

Back
Top