what type of tables will be used in User defined functions of sql server?

Posted by Udaysimha under Sql Server on 2/4/2012 | Points: 10 | Views : 848 | Status : [Member] | Replies : 1
Hi All
Please let me know what type of tables will be used in User defined functions of sql server.
Thanks

uday


Responses

Posted by: Niladri.biswas on: 2/8/2012 [Member] Platinum | Points: 25

Up
0
Down
You cannot use TEMP table directly inside UDF.The alternate to do so is to use synonyms.Otherwise u can use physical table,table variable,derive table etc. inside UDFs.

Best Regards,
Niladri Biswas

Udaysimha, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response