Back to OIM Explorer

dbo.QBM_FCVStringTailRemove_1N

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 313 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_FCVStringTailRemove source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

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