Back to OIM Explorer

dbo.QBM_FCVSchemaDatatypeToIntern

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 973 characters

Interpretation

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

Relations

  • No extracted relations.

Typed Edges

  • No typed edges extracted for this source.

References

  • No direct source references extracted.

Referenced By

Complete Source

SQL75 lines
1CREATE FUNCTION dbo.QBM_FCVSchemaDatatypeToIntern(2  @SchemaDatatype nvarchar(256),3  @SchemaMaxLen int4) RETURNS int5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @erg int9  SELECT @erg = 710  IF isnull(sign(@SchemaMaxLen),11  0) = -112  BEGIN13    IF @SchemaDatatype = 'varbinary'14    BEGIN15      SELECT @erg = 716    END17    ELSE18    BEGIN19      SELECT @erg = 1020    END21    RETURN(@erg)22  END23  SELECT @erg = CASE @SchemaDatatype24  WHEN 'Binary' THEN25  726  WHEN 'bit' THEN27  028  WHEN 'char' THEN29  630  WHEN 'datetime' THEN31  532  WHEN 'decimal' THEN33  434  WHEN 'float' THEN35  336  WHEN 'image' THEN37  738  WHEN 'int' THEN39  140  WHEN 'bigint' THEN41  242  WHEN 'money' THEN43  444  WHEN 'nchar' THEN45  646  WHEN 'ntext' THEN47  648  WHEN 'numeric' THEN49  450  WHEN 'varchar' THEN51  652  WHEN 'real' THEN53  354  WHEN 'smalldatetime' THEN55  556  WHEN 'smallint' THEN57  158  WHEN 'smallmoney' THEN59  460  WHEN 'text' THEN61  1062  WHEN 'timestamp' THEN63  764  WHEN 'tinyint' THEN65  166  WHEN 'uniqueidentifier' THEN67  768  WHEN 'varbinary' THEN69  770  WHEN 'nvarchar' THEN71  672  ELSE 773  END endLabel:74  RETURN(@erg)75END
Open raw exported source
SQL ยท Raw8 lines
1    create   function dbo.QBM_FCVSchemaDatatypeToIntern (@SchemaDatatype nvarchar(256), @SchemaMaxLen int ) returns int with SCHEMABINDING as begin2 declare @erg int select @erg = 7 if isnull(sign(@SchemaMaxLen),0) = -1 begin if @SchemaDatatype = 'varbinary' begin select @erg = 7  end else begin select3 @erg = 10  end  return(@erg)  end select @erg = case @SchemaDatatype when 'Binary' then 7  when 'bit' then 0  when 'char' then 6  when 'datetime' then4 5  when 'decimal' then 4  when 'float' then 3  when 'image' then 7  when 'int' then 1  when 'bigint' then 2  when 'money' then 4  when 'nchar' then 6 5 when 'ntext' then 6  when 'numeric' then 4  when 'varchar' then 6  when 'real' then 3  when 'smalldatetime' then 5  when 'smallint' then 1  when 'smallmoney'6 then 4  when 'text' then 10  when 'timestamp' then 7  when 'tinyint' then 1  when 'uniqueidentifier' then 7  when 'varbinary' then 7  when 'nvarchar' 7then 6  else 7 end endLabel: return(@erg) end 8