Syntax For create Procedure in SQL Server

[Sujit_Patil]

Hi,
I am create one application using C#.net and SQL Server 2005,
In this application uses procedure,plz give me syntax how to create procedure in SQL Server and how to handle error in stored procedure.

[Renukavani]

Use this

SqlConnection myConnection =
          new SqlConnection("Data Source=IPaddress;Initial Catalog=databasename;Persist Security Info=True;User ID=username;Password=password");


SqlCommand cmd = new SqlCommand("SP name", myConnection);
        cmd.CommandType = CommandType.StoredProcedure;
        SqlParameter par = cmd.Parameters.Add("@MESSAGE ", SqlDbType.Varchar);
        par.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add("param", SqlDbType.NVarChar, 50).Value = "**";

 myConnection.Open();
            cmd.ExecuteNonQuery();
            string strerrormes=par.Value;

Database side
IF @@ERROR <> 0
SET @MESSAGE ='FAILURE'

RETURN

[kvprajapati]

>plz give me syntax how to create procedure in SQL

Purchase and read PL-SQL books. Have a look at this MSDN article - http://msdn.microsoft.com/en-us/library/ms190782%28SQL.90%29.aspx