Hi Kamil, great video. I have few doubts, can we define user defined scalar function and use cursor command in fabric, if not what would be the work arround, please let me know. Thank you
Thanks. No, these features are not supported in this version of SQL (it's not full SQL Server or Azure SQL Database). While I may understand the need for UDF, I'm not sure why you need cursors? For last 20 years I used cursors only few times (SQL Server) and it was always in OLTP databases.
Hi Kamil, great video. I have few doubts, can we define user defined scalar function and use cursor command in fabric, if not what would be the work arround, please let me know. Thank you
Thanks. No, these features are not supported in this version of SQL (it's not full SQL Server or Azure SQL Database). While I may understand the need for UDF, I'm not sure why you need cursors? For last 20 years I used cursors only few times (SQL Server) and it was always in OLTP databases.