Run all UDF-Functions in a loop

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 2008 Forums

Transact-SQL (2008)

Run all UDF-Functions in a loop

Author

Topic

gpc44
Starting Member

35 Posts

Posted - 2012-04-03 : 09:00:26

Hi,
i want to run all UDF in a Loop or CTE. I wrote this CTE an want to execute the functions with dynamic SQL or whatever ...
Thank you
Nicole

WITH CTE (name)
AS
(
SELECT name FROM sys.sysobjects WHERE name LIKE 'ld_%'AND xtype = 'IF'
)

SELECT @sql = 'SELECT * FROM ' + name + '()'

DonAtWork
Master Smack Fu Yak Hacker

2167 Posts

Posted - 2012-04-03 : 09:38:49

Your question is not very clear. What exactly are you trying to accomplish? Not HOW, but WHAT.

How to ask: http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx
For ultra basic questions, follow these links.
http://www.sql-tutorial.net/
http://www.firstsql.com/tutor.htm
http://www.w3schools.com/sql/default.asp

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-04-04 : 18:31:13

whats the need of this?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources