Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Computer Certification > MCSD > Interview Questions Feb 01 2006

Reply
Thread Tools

Interview Questions Feb 01 2006

 
 
Jobs
Guest
Posts: n/a
 
      01-31-2006

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
http://www.velocityreviews.com/forums/(E-Mail Removed)
Looking for a onsite job mail your resumes at
(E-Mail Removed)

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Interview Questions Feb 22, 2006 Jobs MCSD 0 02-22-2006 05:10 PM
Interview Questions Feb 22, 2006 Jobs Microsoft Certification 0 02-22-2006 05:09 PM
Interview Questions Feb 20, 2006 Jobs MCSD 0 02-20-2006 03:36 AM
Interview Questions Feb 06, 2006 Jobs MCSD 0 02-06-2006 06:02 PM
Interview Questions Feb 01 2006 Jobs MCAD 0 01-31-2006 04:35 PM



Advertisments