Hi,

Could anyone explain the Stored Proc vs Functions from Performance perpestive. I know Function perform row by row processing but when i execute the same insert statement (say for instance, 5 insert statement) in storedprocedure it also perform row by row processing as function do. What make the difference w.r.t Performance/network congestion.

Thanks in advance,
Chandra

__________________
Thanks,
Chandra

Function and Procedures have different use, rather than performance. Function is used to return single value, for example if you want to convert Centigrade to Fahrenheit, you can write SELECT CENTIGRADE(Temperature) FROM TABEL tblWEATHER. Here CENTIGRADE is custom function. Stored Procedures are basically used where you want to execute set of statements in one call.

Hope this helps!


Mujahid Khaleel
Web designing, development, E-commerce applications.