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 : 1703 | 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

Reply | Reply with Attachment

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

0	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

Latest Posts