1
Hi Jasbeer Singh
I know User defined functions have no access to structural and Permanent Tables.but why?
1
You can not use temp table in user define function.
1
Hi Pankaj,
You can't use temp table in UDF. User defined functions have no access to structural and Permanent Tables. You can use table variables instead of Temp tables and they will give you same result.
Please mark as answer if it solves or clears your confusion.
Regards
Jasbeer Singh
0
Well good question u have asked, WHY...
please check below link...
https://ask.sqlservercentral.com/questions/90201/table-variables-in-user-defined-functions.html
0
you can use a table variable in your proc and pass it as a table-valued-parameter to the function