Scalar- Value Function and Simple Table-Valued Function in SQL Server.

Question

Hi friends I want to know what is difference between Scalar- value function and Simple table-valued function in SQL Server. Thank you.

Sudheshwer Rai · Answer

In Sort- Table valued functions return as table. And scalar valued function return single value with return keyword.

Satyapriya Nayak · Answer

Hi Vipendra Please refer the below links http://www.sqlteam.com/article/intro-to-user-defined-functions-updated http://www.simple-talk.com/sql/t-sql-programming/sql-server-functions-the-basics/ http://thehobt.blogspot.in/2009/02/scalar-functions-vs-table-valued.html Thanks