Back to OIM Explorer

dbo.QBM_FGICmp_Like_Objectkey

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL19 lines
1CREATE FUNCTION dbo.QBM_FGICmp_Like_Objectkey(2  @Value varchar(138),3  @TableName varchar(30)4) RETURNS BIT5  WITH SCHEMABINDING6AS7BEGIN8  RETURN(CASE9  WHEN @value IS NULL THEN10  011  WHEN @TableName IS NULL THEN12  013  WHEN @TableName LIKE '%[%]%' THEN14  1/015  WHEN @Value LIKE '<Key><T>' + @TableName + '</T>%' THEN16  117  ELSE 018  END)19END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QBM_FGICmp_Like_Objectkey( @Value varchar(138) , @TableName varchar(30) ) returns bit with SCHEMABINDING as begin return2 ( case when @value is null then 0 when @TableName is null then 0 when @TableName like '%[%]%' then 1/0 when @Value like '<Key><T>' + @TableName + '</T>%'3 then 1 else 0 end ) end 4