By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,806 Members | 1,829 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,806 IT Pros & Developers. It's quick & easy.

Making a Stored Procedure in MS-SQL 2000

P: n/a

Sorry, this is a very easy question. I have to create a stored
procedure in a SQL SERVER Database.

I have read lots on MSDN about the syntax of this stored procedure :

-- get everything out of contact table
SELECT * FROM tblContact
but I cannot find anywhere how to actually add this procedure, so that
it is accessable in my VB.NET program.

What I am asking is : what screen do I type this into? Is it Query
Analyzer, if so where?

Its got me oh so confused. When I've got time i'll read all about SQL
Server, but for this morning I need to know how to simply add that
Stored Procedure to my database.
Thanks LOADS for any help.

Jul 23 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Type the CREATE PROCEDURE code in Query Analyzer. You can then execute
the proc from VB using the ADO command.execute method for example.
David Portas
SQL Server MVP

Jul 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.