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
jobatyourdoorstep@xxxxxxxxxxx
Looking for a onsite job mail your resumes at
jobatyourdoorstep@xxxxxxxxxxx

.

Relevant Pages

  • Interview Questions Feb 01 2006
    ... What's the difference between Stored Procedure and User Defined ... Following are some major differences between a stored procedure and ... 4)If there is an error in UDF its stops executing. ... 5)UDF can not make permanent changes to server environments while ...
    (comp.databases.ms-sqlserver)
  • Interview Questions Feb 01 2006
    ... What's the difference between Stored Procedure and User Defined ... Following are some major differences between a stored procedure and ... 4)If there is an error in UDF its stops executing. ... 5)UDF can not make permanent changes to server environments while ...
    (microsoft.public.cert.exam.mcsd)
  • Re: Poor performance when executing stored procedure
    ... If SQL Server ... has to re-compile the SP, it takes shorter time to compile a smaller stored ... Poor performance when executing stored procedure ...
    (microsoft.public.sqlserver.programming)
  • Stored procedure does not complete until result set is retrieved from ODBC
    ... I have a SQL Server Stored procedure that I am executing via ODBC. ... -- Start Code without cursor ...
    (microsoft.public.sqlserver.odbc)
  • Re: SQL/ASP - Timout Problem w/ Particular Statement
    ... inside the stored proc and i was executing one query or the other based ... > My asp page calls a stored procedure passing many parameters. ... > I used the SQL profiler to get the exact stored procedure with all ... > After executing 2-3 times the stored procedure in the Query Analyzer, ...
    (comp.databases.ms-sqlserver)