Best way to call a stored procedure

FAQ

Profile

Best way to call a stored procedure

Database Help (Home) -> Visual Basic

Next: how can i make sequrity to my database ?

Author

Message

Mike4

External

Since: Jun 14, 2004
Posts: 1

(Msg. 1) Posted: Mon Jun 14, 2004 2:17 pm Post subject: Best way to call a stored procedure Archived from groups: comp>lang>basic>visual>database (more info?)

Hi There are two ways to execute a stored procedure using ADO - call "exec sp_myproc val1,val2" statement over ADO - use Command/Parameters objects to initialize and call the stored procedure. Which is a efficient way and why Appreciate your response Thanks Mike >> Stay informed about: Best way to call a stored procedure

Display posts from previous:

Related Topics:

Passing Var's to Procedure - what should I change in the procedure below that I can call it with more variables...(i,e) File2SqlBlob("c:\pic1.jpg","tablename","colname") I am having problem defining the variables within the procedure ..thank you for ...

sql query returns in wrong format - Hi, Hope someone can help me with this. I have MS SQL 2000 database where i have Table "PriceList" and there a column "Pricemk" wich is data type "money". All data in this column is in form "10001,35". So why when...

arrays - is there a way to concatenate the contents of an array (looping through the array) and storing each item in a comma delimited string? Thanks!

DataReport PageBreak - Hi everyone, I would like to know how to force pagebreak in a datareport for example after 5 records printed. Thank you all

Possible Use of a Cursor - I have a complex query that I hope I can explain it well enough for everyone to understand. I have a table that contains information for work instructions. Contained in the table are "MACHINE_PROC" these are groupings of machining processes....

	Database Help (Home) -> Visual Basic	All times are: Pacific Time (US & Canada)
Page 1 of 1

You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum