Back to OIM Explorer

dbo.QBM_FSQConstraintName

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL32 lines
1CREATE FUNCTION dbo.QBM_FSQConstraintName(2  @UID_QBMRelation varchar(38)3) RETURNS nvarchar(644)5  WITH SCHEMABINDING6AS7BEGIN8  DECLARE @erg nvarchar(64)9  SELECT @erg =10  LEFT(@UID_QBMRelation,11  3) + '_RF' + SUBSTRING(@UID_QBMRelation,12  5,13  33)14  SELECT15    @erg = replace(@erg,16    N '/',17    N '')18  SELECT19    @erg = replace(@erg,20    N '-',21    N '')22  SELECT23    @erg = replace(@erg,24    N '#',25    N '')26  IF NOT(upper(substring(@erg, 1, 1)) >= N 'A' AND upper(substring(@erg, 1, 1)) <= N 'Z')27  BEGIN28    SELECT @erg = N 'C' + @erg29  END30  ende:31  RETURN(@erg)32END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QBM_FSQConstraintName (@UID_QBMRelation varchar(38) ) returns nvarchar(64) with SCHEMABINDING as begin declare @erg nvarchar2(64) select @erg = LEFT(@UID_QBMRelation, 3)  + '_RF' + SUBSTRING(@UID_QBMRelation, 5,33) select @erg = replace(@erg, N'/', N'') select @erg = replace(@erg3, N'-', N'') select @erg = replace(@erg, N'#', N'') if not (upper(substring(@erg, 1,1)) >= N'A' and upper(substring(@erg, 1,1)) <= N'Z' ) begin select 4@erg = N'C' + @erg end ende: return(@erg) end 5