Mega Code Archive

 

Categories / MSSQL Tutorial / Procedure Function

 

Scalar functions are functions that return a single value

Scalar functions can accept zero or more input parameters. Syntax for Creating Scalar Functions CREATE FUNCTION [ owner_name. ] function_name     ( [ { @parameter_name scalar_parameter_data_type [ = default ] } [ ,...n ] ] ) RETURNS scalar_return_data_type [ WITH { ENCRYPTION | SCHEMABINDING } [,...n] ] [ AS ] BEGIN     function_body     RETURN scalar_expression END