Back to OIM Explorer

dbo.QBM_FCVStringTailRemove

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL19 lines
1CREATE FUNCTION dbo.QBM_FCVStringTailRemove(2  @In nvarchar(max),3  @HangPattern nvarchar(64)4) RETURNS nvarchar(max5)6  WITH SCHEMABINDING7AS8BEGIN9  DECLARE @erg nvarchar(max)10  SELECT @erg = @In11  WHILE @erg LIKE @HangPattern12  BEGIN13    SELECT @erg =14    LEFT(@erg,15    (datalength(@erg) /2) -1)16  END17  EndLabel:18  RETURN(@erg)19END
Open raw exported source
SQL ยท Raw4 lines
1  create   function dbo.QBM_FCVStringTailRemove (@In nvarchar(max) , @HangPattern nvarchar(64) ) returns nvarchar(max) with SCHEMABINDING as begin2 declare @erg nvarchar(max) select @erg = @In while @erg like @HangPattern begin select @erg = left(@erg, (datalength(@erg) /2 ) -1) end EndLabel: return3(@erg) end 4