how to Write Stored Procedure in SQL SERVER?

Do a search on the internet and go through some tutorials on writing stored procedures.
Try out the msdn website.

You might also want to pick up some basic books on stored procedures and go through them.

You need to learn how to create Stored Procedure Take a look at given links
How to: Create a Stored Procedure[^]
How to Write Store Procedure[^] and
SQL Server Stored Procedures for Beginners[^]

Go to your Sql server Stored procedure, create new stored procedure.
Then you just provide your stored procedure name in create procedure and after that declare your parameters.

Go to your SQL SERVER.... Select the db-- Programabillity-------Storedprocedure----New Stored Procedure

*************************************************************

or Copy the below code and paste in sqlserver. and make nessecary changes

CREATE PROCEDURE <Procedure_Name, sysname, ProcedureName>
    -- Add the parameters for the stored procedure here
    <@Param1, sysname, @p1> <Datatype_For_Param1, , int> = <Default_Value_For_Param1, , 0>,
    <@Param2, sysname, @p2> <Datatype_For_Param2, , int> = <Default_Value_For_Param2, , 0>
AS
BEGIN
    -- SET NOCOUNT ON added to prevent extra result sets from
    -- interfering with SELECT statements.
    SET NOCOUNT ON;

    -- Insert statements for procedure here
    SELECT <@Param1, sysname, @p1>, <@Param2, sysname, @p2>
END
GO