Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 how to create a dynamic query and run it

Author  Topic 

khufiamalik
Posting Yak Master

120 Posts

Posted - 2009-04-20 : 00:12:00
Hello All,
I have a sp that gets the name of UDF as input and creates that Function.This function will always return a BIT value.
But I am unable to create a dynamic query for UDF and Run it.

Please Help me in this regard.


Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2009-04-20 : 03:18:48
Why do you want to create UDF dynamically?
www.sommarskog.se/dynamic_sql.html


Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -