Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
renjithgk
Starting Member
3 Posts |
 Posted - 2008-04-04 : 09:09:01
|
| Hi All,My question is :Why we are using udf inside stored procedures ?Will it make any performance faster for the stored procedure to execute ?awaiting your reply.ThanksRenjith |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2008-04-04 : 09:18:52
|
| It depends upon what type of UDF it is? How it is coded? What is the underlying data set on which it operates?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2008-04-04 : 09:23:28
|
| UDF's are usually created to encapsulate a set of business logic that needs to be repeated throughout an applicaton, and be used in the context of a set based operationSo with that said, you really have to give us a little (read alot) more information.Brett8-)Hint: Want your questions answered fast? Follow the direction in this linkhttp://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspxAdd yourself!http://www.frappr.com/sqlteam |
|
|
|
renjithgk
Starting Member
3 Posts |
Posted - 2008-04-04 : 09:43:19
|
| ok thanks |
|
|
|
renjithgk
Starting Member
3 Posts |
Posted - 2008-04-04 : 09:47:19
|
| Hi all,Once again.can anyone provide me a link where i can learn the basics of UDF inside storedprocedure.how we are implementing udf inside storedprocedure.Thanks once again!! |
|
|
|
raky
Aged Yak Warrior
767 Posts |
Posted - 2008-04-04 : 09:54:21
|
| Read Books Online |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Stored Procedure Vs User Defined Functions