Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

The syntax for creating a simple table-valued function

CREATE FUNCTION [owner_name.]function_name     ([@parameter_name data_type [= default]] [, ...]) RETURNS TABLE [WITH {ENCRYPTION|SCHEMABINDING|ENCRYPTION,SCHEMABINDING}] [AS] RETURN [(] select_statement [)]