tag:blogger.com,1999:blog-495177919198719500.post6253173237423689437..comments2023-12-27T20:52:29.483-08:00Comments on Microsoft Sql Server Tutorials: SQL Server: Return Multiple Values from a FunctionSuprotim Agarwalhttp://www.blogger.com/profile/08349831623922214390noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-495177919198719500.post-43087250341002324392011-02-10T02:44:21.908-08:002011-02-10T02:44:21.908-08:00Suppose you want to split the data and join with a...Suppose you want to split the data and join with another table you can use a table-valued function. If you want to do lot of calculations(including updating or deleting data) and return only a value, you can use a stored procedure with output parameterMadhivananhttp://www.beyondrelational.com/blogs/madhivanannoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-82557961278072616722011-02-10T01:53:14.570-08:002011-02-10T01:53:14.570-08:00Very nice query. I have a question. When will I us...Very nice query. I have a question. When will I use a table value function and when to use a Stored Procedure which returns one or more Output Parameters?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-59948366083820275072011-02-09T22:45:32.073-08:002011-02-09T22:45:32.073-08:00Nisha,
Yes it is also known as table-valued funct...Nisha,<br /><br />Yes it is also known as table-valued functionMadhivananhttp://www.beyondrelational.com/blogs/madhivanannoreply@blogger.comtag:blogger.com,1999:blog-495177919198719500.post-47429136976942452882011-02-09T21:30:24.106-08:002011-02-09T21:30:24.106-08:00Madhivanan sir, is this also called a table-valued...Madhivanan sir, is this also called a table-valued function that you have shown in this example?Nishanoreply@blogger.com