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 |
|
JacobPressures
Posting Yak Master
112 Posts |
 Posted - 2005-08-11 : 12:08:20
|
| Can someone tell me the basic difference between a UDF and SP?I know that UDF are not ascii standard. But what is the difference in their purpose? Is it similar to Sub procedures and User-defined functions in VB? |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-08-11 : 12:27:27
|
a sproc is a way to group many statements into one single unit.so is UDF with difference being you can call UDF for every row in resultset while you can't do the same for sproc.there's also limited stuff you can do in UDF which is nicely explained in User-defined functions section in BOL.Go with the flow & have fun! Else fight the flow  |
 |
|
|
JacobPressures
Posting Yak Master
112 Posts |
Posted - 2005-08-11 : 14:21:28
|
| These articles have helpedhttp://www.aspfaq.com/show.asp?id=2537http://builder.com.com/5102-6388-1045463.htmlhttp://www.devx.com/gethelpon/10MinuteSolution/16499 |
|
|
|
|
|
|
Stored Procedures vs. User Defined Functions