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 |
|
mahimam_2004
Starting Member
40 Posts |
 Posted - 2006-05-16 : 01:30:05
|
| Hi,What is the difference between Inline-table value function and multi statement table value function?Thanks In Advance |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-16 : 03:27:38
|
post your requirements, have us take a look of what you already did and then you can decide which one you'll use  --------------------keeping it simple... |
 |
|
|
SreenivasBora
Posting Yak Master
164 Posts |
Posted - 2006-05-17 : 15:49:05
|
| Inline UDF ---> Simply returns the rowset as table.Ex: CREATE FUNCTION SalesByStore (@storeid varchar(30)) RETURNS TABLE ASRETURN (SELECT title, qty FROM sales s, titles t WHERE s.stor_id = @storeid and t.title_id = s.title_id)Multi-statement table-valued function ----> is also returns the rowset as table. But you can alos perform create Tablevariables and update/Insert/Delete the data.see books online for more details.With RegardsBSR |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2006-05-17 : 23:43:27
|
it's #2 question of the 10 questions in a terminology homeworkhe atleast spread them out  --------------------keeping it simple... |
|
|
|
PSamsig
Constraint Violating Yak Guru
384 Posts |
Posted - 2006-05-18 : 01:53:45
|
| Oh my they are sweet (implying blissfull ignorance), when shouldn't they be used an how do they affect performance?-- This one's tricky. You have to use calculus and imaginary numbers for this. You know, eleventeen, thirty-twelve and all those. |
|
|
|
|
|
|
Difference