Forum Discussion

Salvor71's avatar
Salvor71
Regular Visitor
1 year ago
Solved

Fabric SQL Database User defined functions

I've just started fiddling with Fabric SQL Database trying to create one of the db I use on my on-premises Sql Server and I discovered that scalar-valued and multi-statement table-valued functions ar...
  • Salvor71's avatar
    1 year ago

    Hi V-yubandi-msft,

    thank you for replying.

    I realized I that the documentation (CREATE FUNCTION (Azure Synapse Analytics and Microsoft Fabric) - SQL Server | Microsoft Learn) is actually referring to the SQL Analytics endpoint where I could successfully create an in-line table valued function, but of course not the other two kinds of functions. On the other end, in the SQL database itself I could create all three kinds. Perhaps the docs are a bit misleading, and are not including the new database type yet. Also I had too many windows open and didn't realize I was working on the wrong one ğŸ˜Š.