foreach (UserDefinedFunction udf in db.UserDefinedFunctions)
            {
                if (!udf.IsSystemObject)
                    foreach (var v in udf.Script())
                        sb.Append(v + "\nGO\n");
            }

quote:

---

Originally posted by mohdowais

A couple of slightly less cunning ways would be:

1. Keep track of how many function declarations failed and re-run the CREATE statements until you get no errors
2. Use the brilliant dm_sql_referenced_entities function to identify which other objects this particular function depends on. You could perhaps store a list of all previously created objects in a hashtable and if any of the objects that are required by this function are not yet created, you could either create them first or defer creation of this function until they are ready.

OS

---

StringBuilder sb2 = new StringBuilder();
            Queue<string> funcList = new Queue<string>();
            Queue<UserDefinedFunction> udfq = new Queue<UserDefinedFunction>();

            foreach (UserDefinedFunction udf in db.UserDefinedFunctions)
            {
                if (!udf.IsSystemObject)
                {
                    foreach (var v in udf.Script())
                        sb2.Append(v + "\nGO\n");

                    funcList.Enqueue(sb2.ToString());
                    sb2 = new StringBuilder();

                    udfq.Enqueue(udf);
                }
            }

            while(udfq.Count != 0)
            {
                var flag = false;
                var current = udfq.Dequeue();

                foreach (var userDefinedFunction in udfq)
                    if (funcList.Peek().Contains(userDefinedFunction.Name))
                    {
                        flag = true;
                        break;
                    }

                if(!flag)
                {
                    sb.Append(funcList.Dequeue());
                }
                else
                {
                    funcList.Enqueue(funcList.Dequeue());
                    udfq.Enqueue(current);
                }
            }

CREATE FUNCTION func1()
/*some calls here to func2*/
GO

CREATE FUNCTION func2()
/*cleverness here*/
GO

quote:

---

Originally posted by russell

I don't get errors when I do it.

Tested in SQL 2005, 2008, 2008R2.

---

CREATE FUNCTION dbo.F1(@num INT)
	RETURNS INT
BEGIN
	RETURN dbo.F2(@num);
END
GO

-- select dbo.F2(1) --<-- this would throw an error
-- GO

CREATE FUNCTION dbo.F2(@num INT)
	RETURNS INT
BEGIN
	RETURN @num*2;
END
GO

SELECT dbo.F1(1);

DROP FUNCTION dbo.F2, dbo.F1;

CREATE FUNCTION dbo.F1(@num INT)
	RETURNS INT WITH SCHEMABINDING
BEGIN
	RETURN dbo.F2(@num);
END
GO

CREATE FUNCTION dbo.F2(@num INT)
	RETURNS INT WITH SCHEMABINDING
BEGIN
	RETURN @num*2;
END
GO

CREATE FUNCTION [dbo].[ClinicSchedule](@StartDate datetime,@EndDate datetime)
RETURNS TABLE as
RETURN 
SELECT c.dt FROM ClinicOpenDays(@StartDate,@EndDate) as c
WHERE c.dt NOT IN (SELECT Date FROM Holidays)

GO

quote:

---

Originally posted by russell

Saw the Dependency Walker Class?

---