Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Support non-deterministic functions in scalar UDFs in Fabric Data Warehouse

Currently, scalar UDF containing non-deterministic functions (such as GETDATE) can't be used in combination in a query with a user table.

 

e.g. create dbo.udf () returns datetime2 as begin return getdate() end

this query would fail:

select col1, dbo.udf() as udf_output

from usertable1

Status: Under Review
Comments
SMATIN
Microsoft Employee
Status changed to: Under Review