SA0014 : Avoid ‘fn_’ prefix when naming functions
The topic describes the SA0014 analysis rule.
Avoid ‘fn_’ prefix when naming functions
This rule checks for user defined scalar functions with ‘fn_’.
Though this practice is supported, it is recommended that the prefixes not be used to avoid name clashes with Microsoft shipped objects.
The rule has a Batch scope and is applied only on the SQL script.
Rule has no parameters.
The rule does not need Analysis Context or SQL Connection.
Naming Rules, Bugs
There is no additional info for this rule.
1CREATE FUNCTION dbo.fn_myfunction 2( 3 @value AS int 4) 5RETURNS int 6WITH EXECUTE AS CALLER 7AS 8 BEGIN 9 SET @value=@value + 1 10END;
|1||SA0014 : Avoid ‘fn_’ prefix when naming functions.||1||20|