Differnce between Stored procedure and user defined functions?

Answer Posted / saiprasad

u cannot change any datatype in database using udf

u can do everything with a storedprocedure

udf cannot be used in XMl Clause but sp's can be used

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is isolation?

571


Which object needs to be closed?

1744


What is data adapter in ado.net with example?

518


Does dapper use ado.net?

598


What is ole in excel?

522






What is full form of ado?

537


What is connected architecture in ado.net?

526


How is entity framework different from ado.net?

488


What are the different ado.net namespaces?

624


What is the difference between SqlCommand and SqlCommandBuilder?

585


What is Data view?

562


What is the use of Dataview?

575


What is a data control clerk?

574


What are the methods of XML dataset object?

615


What is commandbuilder in ado.net?

526