Msg 195: STRING_SPLIT Is Not a Recognized Built-In Function Name

Yesterday, I was writing some Transact SQL to dust off the cobwebs. I got confused when I was playing around with the STRING_SPLIT function, and kept getting the error:

Msg 195, Level 15, State 10, Line 2
'STRING_SPLIT' is not a recognized built-in function name.

I checked my database compatibility level, which must be 130 or higher for the function to be available. My database compatibility level was 160, so that was fine.

Continue reading

Gotchas with Deferred Name Resolution in SQL Server: Stored Procedures, Synonyms, Views, and Functions

Have you ever tried to create an object in SQL Server, but it failed due to a missing table, column, or other dependency? If so, you’ve hit a case where SQL Server doesn’t offer ‘deferred name resolution’.

Continue reading

Why You Shouldn't Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures

I recently published Why You Shouldn’t Hardcode the Current Database Name in Your Views, Functions, and Stored Procedures over on Simple Talk.

Continue reading