lapucca
asked on
How to create a stored procedure in sql 2005?
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?
Thank you.
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?
Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER