T-SQL Tutorial

Msg 195 Level 15 - Is not a recognized built-in function name


On Transact SQL language the Msg 195 Level 15 - Is not a recognized built-in function name means that the function name is misspelled or does not exist.

Msg 195 Level 15 Example:

Invalid select:

SELECT YEAR123('2014-03-01') as 'Col 1',
YEAR(SYSDATETIME()) as 'Col 2';

Message
Msg 195, Level 15, State 10, Line 1
'YEAR123' is not a recognized built-in function name.




Correct select:

SELECT YEAR('2014-03-01') as 'Col 1',
YEAR(SYSDATETIME()) as 'Col 2';

Col 1Col 2
20142014

Other error messages: