How to create a stored procedure in sql 2005?
Posted on 2008-10-16
Hi, In MS SQL Server Management Studio, I clicked File and New but it only offer to create Query.
1. How can I create a stored procedure? Do I just type Create Procedure in the Query editor?
2. How do I name the stored proecude? Internet example of dbo.xxxx. Do I use my login-name.procedure-name? Or can I just give it a prcedure name like MyProcedure?