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: 398911

  More actions

  October 15, 2008 at 8:32 am

  #885262

  Cross-posted here: http://www.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 Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning