Insert value using Table Value Functions (TVF)

home
database
view story

2 Kicks

Insert value using Table Value Functions (TVF)(soliddotnet.com)

submitted by neerajmathur(130) 2 years, 8 months ago

In my last article we discuss about Table Value function…. a real gem in Sql Server 2008… mostly people still using Stored procedure may be they shifted to SQL Server but they are not using TVF right now… In previous if we have to insert some data in table it requires lots of step like creating a table, Store procedure , Insert Data etc.. with TVF it can be done with lots of ease… i am mentioning a small example of TVF which may be helpful in coming days we will discuss more in detail regarding TVF and what kind of Stored procedure we can use in TVF… one more thing i am looking these days is to measure the performance issue of TVF or we can say which one is better TVF or SP

add a comment |category: Database |Views: 11
Tweet