Back to OIM Explorer

dbo.QBM_FSQIsNullClauseCmp

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 1.264 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_FGIColumnDataType source text reference

References

Referenced By

Complete Source

SQL62 lines
1CREATE FUNCTION dbo.QBM_FSQIsNullClauseCmp(2  @TableName varchar(30),3  @columnname varchar(30),4  @TableSynonym varchar(64)5) RETURNS nvarchar(10006)7AS8BEGIN9  DECLARE @erg nvarchar(1000)10  DECLARE @datatype nvarchar(64)11  SELECT12    @datatype = dbo.QBM_FGIColumnDataType(@TableName,13    @columnname)14  IF @datatype IN('int',15  'bigint')16  BEGIN17    SELECT18      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0)'19      GOTO ende20  END21  IF @datatype = 'datetime'22  BEGIN23    SELECT24      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', ''1800-01-01'')'25      GOTO ende26  END27  IF @datatype = 'Float'28  BEGIN29    SELECT30      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0.0)'31      GOTO ende32  END33  IF @datatype = 'Bit'34  BEGIN35    SELECT36      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0)'37      GOTO ende38  END39  IF @datatype IN('varbinary',40  'timestamp')41  BEGIN42    SELECT43      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0x0)'44      GOTO ende45  END46  IF @datatype IN('char',47  'varchar')48  BEGIN49    SELECT50      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', '''' )'51      GOTO ende52  END53  IF @datatype IN('nchar',54  'nvarchar')55  BEGIN56    SELECT57      @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', N'''' )'58      GOTO ende59  END60  SELECT @erg = ' message  this_must_be_an_invalid_datatype' ende:61  RETURN(@erg)62END
Open raw exported source
SQL ยท Raw10 lines
1  create   function dbo.QBM_FSQIsNullClauseCmp (@TableName varchar(30) , @columnname varchar(30) , @TableSynonym varchar(64) ) returns nvarchar(10002) as begin declare @erg nvarchar(1000) declare @datatype nvarchar(64) select @datatype = dbo.QBM_FGIColumnDataType(@TableName , @columnname) if @datatype3 in ( 'int' , 'bigint') begin select @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0)' goto ende end if @datatype = 'datetime' begin select4 @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', ''1800-01-01'')' goto ende end if @datatype = 'Float' begin select @erg = 'ISNULL(' + @TableSynonym5 + '.' + @columnname + ', 0.0)' goto ende end if @datatype = 'Bit' begin select @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0)' goto ende6 end if @datatype in ('varbinary', 'timestamp') begin select @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', 0x0)' goto ende end if @datatype7 in( 'char' , 'varchar') begin select @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', '''' )' goto ende end if @datatype in( 'nchar', 'nvarchar'8) begin select @erg = 'ISNULL(' + @TableSynonym + '.' + @columnname + ', N'''' )' goto ende end  select @erg = ' message  this_must_be_an_invalid_datatype'9 ende: return (@erg) end 10