Lets Have a fun with Technology.

BTemplates.com

Follow by Email

Saturday, November 15, 2008

What is Store Procedure ? -- Store Procedure Advantages



What is Store Procedure?
Store Procedure is nothing but just a set of T-SQL statements combined to
Perform a single task of several tasks. It’s basically like a
Macro so when you invoke the Stored procedure, you actually
Run a set of statements.
In other Word We Can Say that Store Procedure is subprogram that performs a Specific task.
Advantages of Store Procedure
1.  Store Procedure are Faster because they eliminate the need of reparse
And reoptimize.
2.  Reduce Traffic.
3.  Store Procedure is Reusable Object.
4.  Performance and Easy of Maintain ace are to Good Point for Using Store Procedure
5.  They allow faster Execution because it’s in Pre-Compile Statement.
6.  We Can Execute SP in the SP.

PLEASE WRITE YOUR VIEW ON SP IN BELOW COMMENT BOX.


                 First page SP         Second Page SP         Third Page SP           Fourth Page SP

5 comments:

  1. There are Two type of Store Procedure

    1.System Stored Procedure :- Used to manage SQL server and have the prefix sp_


    2.Extended Stored Procedures. :- These are dynamic – link libraries(DLLs) that SQL Server can dynamically load and execute and have the prefix xp_

    ReplyDelete
  2. SP Main advantages is Enhanced security controls. You can grant users permission to execute a stored procedure independently of underlying table permissions.

    ReplyDelete
  3. hi keten,
    anish here

    when i m trying to redirect the page using Response.Redirect method i get the following exception.

    {System.Threading.ThreadAbortException}
    System.Threading.ThreadAbortException: {System.Threading.ThreadAbortException}
    Data: error: cannot obtain value
    HelpLink: error: cannot obtain value
    InnerException: error: cannot obtain value
    Message: error: cannot obtain value
    Source: error: cannot obtain value
    StackTrace: error: cannot obtain value
    TargetSite: error: cannot obtain value


    please suggest the solution of this problem

    ReplyDelete
  4. Hi Anish

    Just Set Your Response.Redirect Second Parameter to False.

    Example.

    Response.Redirect("url",false);

    Hope your Problem Solved.

    ReplyDelete
  5. hi,
    when i m trying to redirect the page using Response.Redirect method i get the following exception.

    Data: error: cannot obtain value
    HelpLink: error: cannot obtain value
    InnerException: error: cannot obtain value

    sol:
    Response.Redirect("url",false);
    this solve my problem but i dont understand the reason behind it
    please if anyone know let me know
    my mail id is bhushan099@gmail.com

    ReplyDelete