What is difference between Inline Table-values Function and Multi-statement Table-vlued Function

• Pravin Patel-491467

  Say Hey Kid

  Points: 674

  More actions

  October 15, 2008 at 7:19 am

  #199377

  If my function result is only one row with 5 column and i need this function frequently.

  in this situation which function is better for me. Which use less memory?

  Either Inline Table-values Function Or Multi-statement Table-vlued Function

• Grant Fritchey

  SSC Guru

  Points: 397721

  More actions

  October 15, 2008 at 8:32 am

  #885262

  Cross-posted here: http://qa.sqlservercentral.com/Forums/Topic586167-145-1.aspx

  Please keep posts to one forum.

  ----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software