You must Sign In to post a response.
  • Category: .NET

    Difference between Scalar-valued and Table Valued Functions in sql server 2005

    Hi,

    Can anyone tell the diffrence between Scalar-valued and Table Valued Functions in sql server 2005.

    Regards,
    Neelima.
  • #175037
    Hi,

    Scalar valued function returns a single value like int,string..
    Table valued function returs a result set as a table ( A table is returned by a user defined function).

  • #175040
    http://www.builderau.com.au/program/sqlserver/soa/Understand-when-to-use-user-defined-functions-in-SQL-Server/0,339028455,339283430,00.htm

  • #175047
    hi,


    Scalar valued function -> int,string,..(singlevalue).
    Table valued function -> returns table.


  • This thread is locked for new responses. Please post your comments and questions as a separate thread.
    If required, refer to the URL of this page in your new post.