User-defined function: Difference between revisions

Content deleted Content added
Reverted good faith edits by Shamilkhanniazi (talk): Not really helpful and added an unreliable source (TW)
m linking
Line 38:
 
Scalar functions return a single data value (not a table) with RETURNS clause. Scalar functions can use all scalar data types, with exception of timestamp and user-defined data types.
Inline table-valued functions return the [[result set]] of a single SELECT statement.
Multistatement table-valued functions return a table, which was built with many TRANSACT-SQL statements.