Back to OIM Explorer

dbo.QBM_FGICmp_Like_Value

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 997 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

  • No direct source references extracted.

Complete Source

SQL51 lines
1CREATE FUNCTION dbo.QBM_FGICmp_Like_Value(2  @Value nvarchar(400),3  @Literal nvarchar(64)4) RETURNS BIT5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(CASE9  WHEN @value IS NULL THEN10  convert(BIT, 0)11  WHEN @Literal IS NULL THEN12  convert(BIT, 0)13  WHEN @Literal LIKE '%[%]%' THEN14  1/015  WHEN datalength(@Literal) IN(2, 6) THEN16  CASE17    WHEN @Value LIKE @Literal + N '%' THEN18  CASE19    WHEN UNICODE(upper(@Value)) = UNICODE(upper(@Literal)) THEN20  convert(BIT, 1)21  ELSE convert(BIT, 0)22  END23  ELSE convert(BIT, 0)24  END25  WHEN @Literal = N 'ReportHeader' THEN26  CASE27    WHEN @Value LIKE N 'ReportHeader%' THEN28  convert(BIT, 1)29  ELSE convert(BIT, 0)30  END31  WHEN @Literal = N 'Digit' THEN32  CASE33    WHEN @Value LIKE '[0-9]%' THEN34  convert(BIT, 1)35  ELSE convert(BIT, 0)36  END37  WHEN @Literal = N 'PropertyLog' THEN38  CASE39    WHEN @Value LIKE 'Common\ProcessState\PropertyLog%' THEN40  convert(BIT, 1)41  ELSE convert(BIT, 0)42  END43  WHEN @Literal = N 'dummy' THEN44  CASE45    WHEN @Value LIKE N '%(dummy)' THEN46  convert(BIT, 1)47  ELSE convert(BIT, 0)48  END49  ELSE 050  END)51END
Open raw exported source
SQL ยท Raw8 lines
1  create   function dbo.QBM_FGICmp_Like_Value( @Value nvarchar(400) , @Literal nvarchar(64) ) returns bit with SCHEMABINDING as begin return (case2  when @value is null then convert(bit, 0) when @Literal is null then convert(bit, 0) when @Literal like '%[%]%' then 1/0   when datalength(@Literal) in3 ( 2, 6) then case when @Value like @Literal + N'%' then case when UNICODE(upper(@Value)) = UNICODE(upper(@Literal)) then convert(bit, 1) else convert(bit4, 0) end  else convert(bit, 0) end  when @Literal = N'ReportHeader' then case when @Value like N'ReportHeader%' then convert(bit, 1) else convert(bit, 50) end when @Literal = N'Digit' then case when @Value like '[0-9]%' then convert(bit, 1) else convert(bit, 0) end when @Literal = N'PropertyLog' then case6 when @Value like 'Common\ProcessState\PropertyLog%' then convert(bit, 1) else convert(bit, 0) end when @Literal = N'dummy' then case when @Value like 7N'%(dummy)' then convert(bit, 1) else convert(bit, 0) end else 0 end ) end 8