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

Hi, Is it possible to create a S

Status
Not open for further replies.
vechalapu

vechalapu

Programmer
May 2, 2001
58
US
Hi,

Is it possible to create a Stored Procedure in VB during Run Time with variable number of parameters?

Thanking You,
 
Sort by date Sort by votes
Are you accessing MS SQL Server?

Why would want to create your stored procedures in VB?

I would recommend creating them on the Server (MSSQL).



reidfl
 
Upvote 0 Downvote
As reidfl suggests you really shouldn't be creating SP's in VB. However, if you really need to (and again I'm with reidfl in wondering why) you can execute the string CreateProcedure etc as you would write in the SP itself.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

2009luca
  • Question
possible to use xml2 or Set WHTTP = CreateObject("WinHTTP.WinHTTPrequest.5.1"), instead code in message
Replies
5
Views
388
2009luca
2009luca
sal21
  • Locked
  • Question
COLORIZE frame border , possible? 1
Replies
6
Views
837
sal21
sal21
sal21
  • Locked
  • Question
CREATE msflexgrid as in xlsx file 2
Replies
8
Views
505
strongm
strongm
sal21
  • Locked
  • Question
NEVER used - get all possible info by ip
Replies
4
Views
498
strongm
strongm
2009luca
  • Locked
difficult to crteate a query very complicated 1
Replies
9
Views
1K
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top