Interview Questions Feb 01 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
jobatyourdoorstepyahoo.co.in
Looking for a onsite job mail your resumes at
jobatyourdoorstepyahoo.co.in