Why can not use temp table in function?

Question

Why can not use temp table in user define function in sql server?

Pankaj Kumar · Answer

Hi Jasbeer Singh I know User defined functions have no access to structural and Permanent Tables.but why?

Subhashkumar Yadav · Answer

You can not use temp table in user define function.

Jasbeer Singh · Answer

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

Manish Kumar · Answer

Well good question u have asked WHY... please check below link... https://ask.sqlservercentral.com/questions/90201/table-variables-in-user-defined-functions.html

Daniel Jones · Answer

you can use a table variable in your proc and pass it as a table-valued-parameter to the function