If you want to know how an existing stored procedure was created, you can use SQL Server Management Studio to automatically generate a "CREATE PROCEDURE" script The following tutorial shows you how to do this:

1. Run SQL Server Management Studio and connect to SQL server.

2. On the Object Explorer window, follow the object tree: Databases > GlobalGuideLineDatabase > Programmability > Stored Procedures > dbo.ShowFaq.

3. Click right mouse button on dbo.ShowFaq. The context menu shows up.

4. Select "Script Stored Procedure as" > "CREATE to" > "New Query Editor Window". The following script will be displayed:

USE [GlobalGuideLineDatabase]

GO

/****** Object: StoredProcedure [dbo].[ShowFaq]

Script Date: 05/19/2007 21:31:35 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE PROCEDURE [dbo].[ShowFaq] AS BEGIN

PRINT 'Number of questions:';

SELECT COUNT(*) FROM Faq;

PRINT 'First 5 questions:'

SELECT TOP 5 * FROM Faq;

END;

CREATE TABLE Faq (Question VARCHAR(80));