Home  Home  Home  Kontakt  Kontakt  Kontakt  Inhalt  Inhalt  Inhalt  Blog  Blog  Blog  FAQ  FAQ  FAQ

Stubs

Bookmarks

Allgemeine Stubs für Procedure resp. Function

IF NOT EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[utl_log].[FN_GetLogMethod]') AND type IN ('FN', 'FS'))
  EXEC sp_executesql N'CREATE FUNCTION [utl_log].[FN_GetLogMethod] (@a int) RETURNS int AS BEGIN /* Stub */ RETURN @a END'
GO

IF NOT EXISTS(SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[utl_log].[SP_LogInfo]') AND type IN ('P'))
  EXEC sp_executesql N'CREATE PROCEDURE [utl_log].[SP_LogInfo]  AS BEGIN /* Stub */ SELECT 1; END'
GO

Function ohne Argument

-- fix (forward declaration)
ALTER FUNCTION [utl_log].[FN_GetLogMethod] () RETURNS int AS BEGIN /* Stub */ RETURN 1; END;