Entry

Database: Microsoft: SQL server: Stored procedure: Create: How to create stored procedure, manually?

Dec 31st, 2003 16:19
Knud van Eeden,

----------------------------------------------------------------------
--- Knud van Eeden --- 14 December 2003 - 11:48 pm -------------------

Database: Microsoft: SQL server: Stored procedure: Create: How to 
create stored procedure, manually?

---

Steps: Overview:

 1. -Start Microsoft SQL server Enterprise manager

 2. -Select a database in the left pane,
     by clicking on the '+' to expand
     then clicking on the name of that
     database (e.g. 'Northwind') to
     highlight it

 3. -right click

 4. -select from list 'New'

 5. -select from list 'Stored Procedure'

 6. -Add possibly some text in the default
     template text

      CREATE PROCEDURE [OWNER].[PROCEDURE NAME] AS

     Note:

     For some examples see e.g. the
     default present 'Northwind' database
     in Microsoft SQL server.

 7. -click button 'Save Template As'
     when finished

---
---

Internet: see also:

---

Database: Microsoft SQL server: SQL: Operation: Overview:Can you give 
an overview of SQL operations?
http://www.faqts.com/knowledge_base/view.phtml/aid/27560/fid/147

----------------------------------------------------------------------