Stored Procedures in Asp.net , Syntax for creating Stored Procedure with examples

Stored Procedures in Asp.net , Syntax for creating Stored Procedure with examples : in asp one of the main topic is Stored Procedures so here we give all information about Stored Procedures in asp dot net with examples
what is Stored Procedures in Asp.net ? 

A Stored Procedure is a Database object which stores  pre-complied  set of queries/statements.  When ever we called a stored procedure Queries with in stored procedure will not be compiled rather they will run directly.

Syntax for creating Stored Procedure:

given below we gave the Syntax for creating Stored Procedure so please follow the below syntax

Syn: Create Procedure  [procedure Name]

         (<Parameters List>)

         As

         Begin

         {Statements}

         End

Example Stored Procedures in Asp.net  : 

Create Procedure  Sp_find

(@Eno int)

                   As

                   Begin

                   Select * from Employee where Eno=@Eno

                   End

Syn: Create Procedure  [procedure Name]

         (<Parameters List>)

         As

         Begin

         {Statements}

         End

Example: Create Procedure  Sp_find

(@Eno int)

                   As

                   Begin

                   Select * from Employee where Eno=@Eno

                   End..

Latest Walkins 2013(updated every day )

Hyderabd Walkins 2013	walkins in chennai2013-14	walkins in Chandigarh2013
Walkins In Mumbai 2013	pune In Walkins 2013	Kolkata in walkins 2013
Ahmedabad JOBS 2013	Banglore walkins	Dotnet jobs