Back to OIM Explorer

dbo.QBM_FSQIsNullClauseSet

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 640 characters

Interpretation

  • Database function. Usually supports views, validation, or calculated predicates; look at referenced-by entries for callers.

Relations

  • No extracted relations.

Typed Edges

  • references source dbo.QBM_FSQIsNullClauseCmp source text reference

References

Referenced By

Complete Source

SQL34 lines
1CREATE FUNCTION dbo.QBM_FSQIsNullClauseSet(2  @TableName varchar(30),3  @columnname varchar(30),4  @TableSynonym varchar(64)5) RETURNS nvarchar(10006)7AS8BEGIN9  DECLARE @erg nvarchar(1000)10  IF EXISTS(11    SELECT TOP 1 112    FROM sys.tables t13    WITH(readpast)14  JOIN sys.columns c15    WITH(readpast)16    ON t.object_id = c.object_id17  JOIN sys.default_constraints d18    WITH(readpast)19    ON c.default_object_id = d.object_id20  WHERE21    t.name = @TableName AND c.name = @columnname)22  BEGIN23    SELECT24      @erg = dbo.QBM_FSQIsNullClauseCmp(@TableName,25      @columnname,26      @TableSynonym)27  END28  ELSE29  BEGIN30    SELECT @erg = @TableSynonym + '.' + @columnname31  END32  ende:33  RETURN(@erg)34END
Open raw exported source
SQL ยท Raw6 lines
1  create   function dbo.QBM_FSQIsNullClauseSet (@TableName varchar(30) , @columnname varchar(30) , @TableSynonym varchar(64) ) returns nvarchar(10002) as begin declare @erg nvarchar(1000) if exists (select top 1 1  from sys.tables t with (readpast) join sys.columns c with (readpast) on t.object_id =3 c.object_id  join sys.default_constraints d with (readpast) on c.default_object_id = d.object_id where t.name = @TableName and c.name = @columnname ) 4begin  select @erg = dbo.QBM_FSQIsNullClauseCmp(@TableName , @columnname, @TableSynonym) end else begin select @erg = @TableSynonym + '.' + @columnname5 end ende: return (@erg) end 6