Search content within the blog

Wednesday, April 22, 2009

Disadvantages of user defined functions over stored procedures

1)UDF Accepts Lesser Numbers of Input Parameters.
UDF can have upto 1023 input parameters, Stored Procedure can have upto 21000 input parameters.

2)UDF can not Call Stored Procedure
Only access to Extended Stored Procedure.

3)UDF can not Execute Dynamic SQL, temporary tables.

4)UDF can not Return XML.

5)UDF does not Support Error Handling
RAISEERROR or @@ERROR are not allowed in UDFs.

No comments:

Post a Comment