Interview Questions Feb 01 2006

Discussion in 'MCAD' started by Jobs, Jan 31, 2006.

  1. Jobs

    Jobs Guest

    What's the difference between Stored Procedure (SP) and User Defined
    Function (UDF)?
    Following are some major differences between a stored procedure and
    user defined functions:-
    1)UDF can be executed using the "SELECT" clause while SP's can
    not be.
    2)UDF can not be used in XML FOR clause but SP's can be used.
    3)UDF does not return output parameters while SP's return output
    parameters.
    4)If there is an error in UDF its stops executing. But in SP's it
    just ignores the error and moves to the next statement.
    5)UDF can not make permanent changes to server environments while
    SP's can change some of the server environment.


    Full Interview Questions for .NET and SQL Server
    http://www.geocities.com/dotnetinterviews/
    Help the community to make job search easier mail your questions to

    Looking for a onsite job mail your resumes at
    Jobs, Jan 31, 2006
    #1
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jobs
    Replies:
    0
    Views:
    411
  2. Jobs
    Replies:
    0
    Views:
    769
  3. Jobs
    Replies:
    0
    Views:
    431
  4. Jobs

    Interview Questions Feb 22, 2006

    Jobs, Feb 22, 2006, in forum: Microsoft Certification
    Replies:
    0
    Views:
    505
  5. Jobs
    Replies:
    0
    Views:
    413
Loading...

Share This Page