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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

stored procedures

Status
Not open for further replies.
EscapeUK

EscapeUK

Programmer
Jul 7, 2000
438
0
0
GB
I have a stored procedure that requires 2 parameters, how do i call this from VB
 
Sort by date Sort by votes
connection.execute "sp_name" & param1 & ", " & param2
or
recordset.open "sp_name" & param1 & ", " & param2, Connection
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

BeatriceC
  • Locked
  • Question
SQL Linked server StoredProcefure job creates temp files
Replies
1
Views
46
pjw001
pjw001
ghiehotamares
  • Locked
  • Question
How to call stored procedure to display records in fron-end data entry
Replies
1
Views
46
fredericofonseca
fredericofonseca
MacroAlan
  • Locked
  • Question
Insert results of huge query into my table with Stored Proc
Replies
1
Views
42
Olaf Doschke
Olaf Doschke
AlphaMann
  • Locked
  • Question
Stored Procedure
Replies
1
Views
34
simian336
simian336
Webkins
  • Locked
  • Question
Need to replace FTP with a SQL Server stored procedure... 1
Replies
2
Views
46
johnherman
johnherman

Part and Inventory Search

Sponsor

Back
Top