SQL Server Performance

diffenrnece between sp and functions/.....

Discussion in 'Getting Started' started by kumar_kisna, Jun 3, 2007.

  1. kumar_kisna New Member

    hi friends.....
    whats r differnces between the stored [procedures and functions...
  2. alzdba Member

    - consider a function is a peice of code applied to every row of your query statement

    - a stored proc is a peice of code that you execute that performs some logic. It cannot be used in a referenced in a query statement.
  3. Madhivanan Moderator

    Read about them sql server help file also


    Failing to plan is Planning to fail
  4. MohammedU New Member

Share This Page