Pass User Defined Table Types (TVP) as arguement of User defined function in MSSQL2008

Question

Hi,

I want to pass User Defined Table types to user defined function, that function has to return two floating type arguement.

please anyone guide me the procedure to do.

Regards

Kasim

Answer 1

Check this blog post for details on using a TVP with a UDF: http://beyondrelational.com/modules/2/blogs/77/posts/11288/table-valued-parameters-to-a-table-valued-function-underappreciated-features-of-microsoft-sql-server.aspx

---

~manoj | email: http://scr.im/m22g
http://sqlwithmanoj.wordpress.com
MCCA 2011

Answer 2

Thanks Manu..

Regards

Kasim

Answer 3

Hi Manu,

I have one more question. how to execute Dynamic SQL in user defined function?

Regards

Kasim

Answer 4

You can't execute dynamic SQL inside a UDF, that's one of a limitation.

Why do you want dynamic SQL? Can't you do it with SP?

---

~manoj | email: http://scr.im/m22g
http://sqlwithmanoj.wordpress.com
MCCA 2011