Showing posts with label inline table valued vs multi statement table valued. Show all posts
Showing posts with label inline table valued vs multi statement table valued. Show all posts

Thursday, 17 November 2016

Table Valued Functions in Sql

What are Table Valued Functions in Sql ? There are two types of “User Defined” fucntions in sql server scalar function ( that returns single value in response to function call )      2. inline table valued ( that returns function result in tabulated form but query can single lined e.g.      3. return (select * from table_name). 1. Inline...