Код

CREATE FUNCTION [dbo].[Parents](@Child char(9))
RETURNS varchar(256)
AS
BEGIN
	DECLARE @res varchar(256)
	set @res  = ''

	while @Child <> '     0   '
		begin
			Select @Child = parentid from SC54250 where id = @Child
			set @res  = '''' + @Child + '''' + ',' + @res
		end

	RETURN Left(@res, Len(@res) - 1)
END
 

Код

CREATE FUNCTION INParent
(
	@NomID char(9),@ParentID char(9)
)
RETURNS int
AS
BEGIN
	-- Declare the return variable here
	DECLARE @cur_id char(9)
	DECLARE @par_id char(9)

	select @cur_id = @NomID
	WHILE @cur_id <> '     0   '
	BEGIN
		 SELECT @par_id = PARENTID FROM  SC282 WHERE ID = @cur_id
		 IF 	par_id = @ParentID
		 BEGIN
				RETURN 1
		 END
		 select @cur_id = @par_id
	END

	RETURN 0

END

 

Код

if not exists(select name from sysobjects where name = 'MyFunc' and type = 'FN')
  select 0
else
  select 1

--или
if not exists(select name from sysobjects where name = 'MyProc' and type = 'P')
  select 0
else
  select 1

--или
if object_id('MyFunc') /*or MyProc*/ is null select 0 else select 1