Why can not use temp table in function?

Manish Kumar9y ago

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

Pankaj Kumar9y ago

Hi Jasbeer Singh

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

+1

Daniel Jones9y ago

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

0

Subhashkumar Yadav9y ago

You can not use temp table in user define function.

0

Jasbeer Singh9y ago

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