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 |
|
Aleph_0
Yak Posting Veteran
79 Posts |
 Posted - 2011-04-12 : 18:34:04
|
| What's the difference? When is it better to use one versus the other?Thanks! |
|
|
Skorch
Constraint Violating Yak Guru
300 Posts |
|
|
mmarovic
Aged Yak Warrior
518 Posts |
Posted - 2011-04-13 : 11:25:28
|
| Table valued functions you typically use to parse entries from non-sql data source (e.g. csv string) and return results as data set. When it is possible to efficiently return data using single select statment, you usually use view.MirkoMy blog: http://mirko-marovic-eng.blogspot.com/ |
 |
|
|
Aleph_0
Yak Posting Veteran
79 Posts |
Posted - 2011-04-13 : 12:21:48
|
quote:
Originally posted by Skorch
See if you find this helpful..http://lmgtfy.com/?q=view+vs+table+valued+functionSome days you're the dog, and some days you're the fire hydrant.
Haha, I can't believe I didn't even think to do a search first! I guess this forum has been so helpful with my last couple of questions that I just automatically went here instead. Thanks for the reminder! |
|
|
|
|
|
|
View vs. table-valued function