I want to create my first stored procedure (I know,...) !
I saw there was a Wizard for it, but... there you can chose all kinds of stored procedures (INSERT - UPDATE - DELETE), except the SELECT one ? :cry:
Are is there another method to this ?
Printable View
I want to create my first stored procedure (I know,...) !
I saw there was a Wizard for it, but... there you can chose all kinds of stored procedures (INSERT - UPDATE - DELETE), except the SELECT one ? :cry:
Are is there another method to this ?
Like I presume, manual work...
I'm guessing you're looking at this in an express edition?
Do you have SQL Server 2000 installed, or SQL Server 2005 Express?
SQL Server 2000
Ah ok then.
If you go into any existing database, and into stored procedures you'll see the syntax and some samples :)