Back to OIM Explorer

dbo.QBM_FSQObjectKeyRepair_fn

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 694 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_FGIPrimaryKeyName source text reference
  • references source dbo.QBM_FGIPrimaryKeyName_F source text reference

References

Referenced By

Complete Source

SQL31 lines
1CREATE FUNCTION dbo.QBM_FSQObjectKeyRepair_fn(2  @TableName nvarchar(64)3) RETURNS nvarchar(max4)5AS6BEGIN7  DECLARE @erg nvarchar(max)8  DECLARE @i int = 19  SELECT @erg = N 'dbo.QBM_FCVElementToObjectKey%n%(''' + rtrim(@TableName) + N ''''10  DECLARE @columnname nvarchar(64)11  SELECT12    @columnname = dbo.QBM_FGIPrimaryKeyName_F(@TableName,13    1)14  SELECT15    @erg = @erg + N ', ''' + @columnname + N ''', ' + @columnname16  SELECT17    @columnname = dbo.QBM_FGIPrimaryKeyName_F(@TableName,18    2)19  IF @columnname > ' '20  BEGIN21    SELECT22      @erg = @erg + N ', ''' + @columnname + N ''', ' + @columnname23    SELECT @i = 224  END25  SELECT @erg = @erg + N ')'26  SELECT27    @erg = replace(@erg,28    N '%n%',29    convert(nvarchar(16), @i))30  RETURN @erg31END
Open raw exported source
SQL ยท Raw6 lines
1   create   function dbo.QBM_FSQObjectKeyRepair_fn (@TableName nvarchar(64)) returns nvarchar(max) as begin declare @erg nvarchar(max) declare @i2 int = 1 select @erg = N'dbo.QBM_FCVElementToObjectKey%n%(''' + rtrim(@TableName ) + N'''' declare @columnname nvarchar(64) select @columnname = dbo.QBM_FGIPrimaryKeyName_F3(@TableName , 1) select @erg = @erg + N', ''' + @columnname + N''', ' + @columnname select @columnname = dbo.QBM_FGIPrimaryKeyName_F(@TableName , 2) if4 @columnname > ' ' begin select @erg = @erg + N', ''' + @columnname + N''', ' + @columnname select @i = 2 end select @erg = @erg + N')' select @erg = replace5 (@erg, N'%n%', convert(nvarchar(16), @i)) return @erg end 6