Hi ramu143,

plz take a look at BOL: CREATE PROCEDURE

Hi ramu143

I Give the syntax for the creating Procedures

Create Proc Proc_Name (Statements Like Condition)

Take a look at this tip:

http://www.mssqltips.com/tip.asp?tip=1495

create proc (name of proc)

@parameter  datatype( which pass in runtime)

we can pass three type para (input, output, (input,output)

as

begin

statement .....

end 

Hi Ramu,

This is the syn. for  creating stored proc from t-SQl with every parameter.

CREATE PROCEDURE

Create a stored procedure.

Syntax
      CREATE PROC[EDURE] [schema.]procedure  
         [ { @parameter [schema.]data_type } 
             [VARYING ] [ = default ] [ OUT[PUT] ]
         ] [ ,...n ] 
         [WITH Option [,...n ]]
      AS { sql_statement [;][ ...n ] | EXTERNAL NAME assembly.class.method }
      [;]

   Options: 
      ENCRYPTION
      RECOMPILE
      EXECUTE_AS_Clause
      [FOR REPLICATION]

   sql_statement 
      [BEGIN] statements [END]

Key
   @parameter   A local parameter in the procedure.
   VARYING      The result set contents may vary: a cursor parameter dynamically constructed by the procedure. 
   default      A default value for the parameter. A constant or NULL
   OUTPUT       Indicates an output parameter.
   RECOMPILE    Do not cache a plan for this procedure - compile at run time.
   ENCRYPTION   Encrypt the text of the CREATE PROCEDURE statement.
   FOR REPLICATION Execute only during replication.
   EXTERNAL NAME   Reference to a method of a .NET Framework assembly.

Example

CREATE PROCEDURE Sales.GetPartsOfType
    @PartCode nvarchar(50) 
AS 
    SELECT PartCode, Description
    FROM Sales.parts
    WHERE PartCode = @PartCode;
GO