what is Difference Scalar Valued Function and Table Valued Function

• pubudugayan127

  Newbie

  Points: 1

  More actions

  July 22, 2008 at 12:11 am

  #92274

  Hi can any body explain me what is the Scalar Valued Function and Table Valued Function and what are the dirrence between them and how they execute in Database?

  thank ton.

• Grant Fritchey

  SSC Guru

  Points: 399332

  More actions

  July 22, 2008 at 6:00 am

  #846325

  Start here:

  http://msdn.microsoft.com/en-us/library/ms191007.aspx

  Move on to here:

  http://msdn.microsoft.com/en-us/library/ms177499.aspx

  "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

• GSquared

  SSC Guru

  Points: 260824

  More actions

  July 22, 2008 at 9:22 am

  #846472

  Start by looking up the word "scalar" in a dictionary. (OneLook.com is good for that kind of thing.) That should make it much more clear.

  - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
  Property of The Thread

  "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon