CREATE FUNCTION [ owner_name.] function_name
( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] ) RETURNS scalar_return_data_type[ WITH < function_option> [ [,] ...n] ] [ AS ]BEGIN
function_body
RETURN scalar_expression
END定义变量时加上=缺省值即可(红色字部分)
( [ { @parameter_name [AS] scalar_parameter_data_type [ = default ] } [ ,...n ] ] ) RETURNS scalar_return_data_type[ WITH < function_option> [ [,] ...n] ] [ AS ]BEGIN
function_body
RETURN scalar_expression
END定义变量时加上=缺省值即可(红色字部分)
select dbo.dd() 而不是 select dbo.dd(default)
returns int
as
begin
return @i+@k
end
调用udf_testfunction让其默认值生效:
select udf_testfunction(default,default)