What is the difference between Inline Table Valued Function and Views?

 Posted by Niladri.Biswas on 7/18/2012 | Category: Sql Server Interview questions | Views: 1747 | Points: 40

A few key differences is listed here

a) View can be materialized (indexed view) and hence performs better. But Inline Table Valued functions cannot be indexed and performance decreases when number of rows increases.

b) Views can have triggers since they can be used to change underlying tables (INSTEAD OF triggers) but not Inline Table Valued functions.

c) We can use CROSS APPLY with the Inline Table Valued function but not with a view.

d) Views don't accept parameter but Inline Table Valued function does so.

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Naraayanan on: 7/20/2012 | Points: 10
Thanks. What is mean by Inline Table Value?How to use it?

Login to post response