Stored Procedures Query

[Adrian]

Is it possible to use stored procedures with SQL Server 2005 express
edition?

1. In "Object Explorer" under "Databases" there is no pocket called "Stored
Procedures". Is such a pocket available anywhere else?

2. Alternatively via C# Visual Studio (Standard Edition), if under "Project"
I select "C#", there is no "Database", and from there I cannot select ""SQL
Server Project" So how - in Visual Studio - can I create a stored procedure?

Many thanks,
Adrian.

 

[Adrian]

Sorry 1. refers to SQL Server Management Studio Express

 

[Guest]

Adrian,

Under Databases, select a particular database.

One of the selections under that database is Programmability. Select that.
Now you will see Stored Procedures. Right-click Stored Procedures and you
will get a menu with New Stored Procedure.

Kerry Moorman

 

[Adrian]

Kerry, that worked fine. Thank you.

Could you plealse also tell me the route through Visual Studio 2005
Standard? (Assuming it is possible to create Stored Procedures under the
Standard VS version.)

Many thanks!
Adrian.

 

[William \(Bill\) Vaughn]

The SQL Server Express Edition supports most of the functionality of the
other versions--including stored procedures. The developer tools, however
are another matter. The free versions of Visual Studio have limited support
of more of the advanced functions so you're going to want to download the
free SQL Server Management Studio Express from Microsoft.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Adrian]

I don't have a "free" version, I have the "Standard" version which wasn't
"free". However the "Add New Item" does not show "Stored Procedures"

Adrian.

 

[William \(Bill\) Vaughn]

http://msdn.microsoft.com/vstudio/products/compare/default.aspx. Sadly, "SQL
Server Support" does not kick in until the Professional edition. Again, the
SSMSE tools can create SPs. Actually, any version can create them--you just
have to roll your own CREATE PROCEDURE code--all the tools do is give you a
template and a way to insert an SQL into the code. Yes, VS pro and better
can step into a SP as well. But if you just need to create one, Visual
Notepad and SQLCMD can do that...

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

 

[Cor Ligthert [MVP]]

Adrian,

You can forever create stored procedures using the program language you are
using. You have than to use the execute.nonquery for that.

I hope this helps,

Cor