Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2005
    Posts
    36

    Unanswered: Difference Between Stored Procedure and Inline Quries

    Hi all,
    What is the Difference between Stored Procedure and Inline Quries...... Is Stored Procedure is faster then Inline Query...
    What is the professional Approch....
    I m using Inline Quries in my Professional Project with Microsoft Application Block..... Someone Said me this is not a professional approch... use stored procedure instead of Inline Quries... i m so puzzled...
    plz guide me.....
    Thanx
    Sajjad
    Regards,
    Sajjad
    C U ON NET
    reply me : sajjaddotnet@yahoo.com

  2. #2
    Join Date
    Feb 2005
    Posts
    36

    differnce between stored Procedure and stored Functions?

    what is the differnce between stored Procedure and stored Functions ????????
    Regards,
    Sajjad
    C U ON NET
    reply me : sajjaddotnet@yahoo.com

  3. #3
    Join Date
    Jun 2003
    Posts
    269
    please check first in any search engine.
    I love cursor,though I never use it.Cos' I dont want to misuse it.
    ----------------------------------------------

    ----cheers
    ----http://mallier.blogspot.com

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Functions are easier to fold into SELECT statements, as they return scalar or table values.
    Stored procedures have fewer programming limitations than user-defined functions, but must be run independently and not as part of a select statement.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •