Answers

Why can not use temp table in function?

Pankaj Kumar

992

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

Answers (5)

Hi Jasbeer Singh

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

You can not use temp table in user define function.

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

Well good question u have asked, WHY...

please check below link...

https://ask.sqlservercentral.com/questions/90201/table-variables-in-user-defined-functions.html

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

Next Recommended Forum

DynamicPIVOTQueries.How toPrint OrderID Also in Final OutPut

How to update table?

Forum Statistics

Please welcome our newest member lasus .
3,086,740 users have contributed to 147,414 threads and 483,524
In the past 24 hours, we have 2 new threads, 7 new posts, and 97 new users.
In last week, the most popular thread is 'How do I find the current working directory in Linux?'.

Upcoming Events

View all