Back to OIM Explorer

dbo.QBM_FSQColumAdd

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 612 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_FSQColumDef source text reference
  • references source dbo.QBM_PColumnAdd source text reference

References

Referenced By

Complete Source

SQL34 lines
1CREATE FUNCTION dbo.QBM_FSQColumAdd(2  @ObjectName nvarchar(64)3) RETURNS nvarchar(max4)5AS6BEGIN7  DECLARE @TableName nvarchar(64)8  DECLARE @ColumnName nvarchar(64)9  DECLARE @Posi int10  DECLARE @erg nvarchar(max)11  SELECT12    @posi = charindex(N '.',13    @Objectname)14  SELECT15    @TableName = substring(@ObjectName,16    1,17    @posi-1)18  SELECT19    @Columnname = substring(@ObjectName,20    @posi+1,21    255)22  DECLARE @a nvarchar(max) = substring(dbo.QBM_FSQColumDef(@TableName, @ColumnName),23  len(@columnname) +2,24  256)25  SELECT26    @erg = CONCAT('exec QBM_PColumnAdd ''',27    @TableName,28    ''', ''',29    @ColumnName,30    ''', ''',31    @a,32    '''')33  RETURN(@erg)34END
Open raw exported source
SQL · Raw5 lines
1   create   function dbo.QBM_FSQColumAdd (@ObjectName nvarchar(64)) returns nvarchar(max) as begin declare @TableName nvarchar(64) declare @ColumnName2 nvarchar(64) declare @Posi int declare @erg nvarchar(max) select @posi = charindex(N'.', @Objectname) select @TableName = substring(@ObjectName, 1, @posi-13) select @Columnname = substring(@ObjectName, @posi+1, 255)  declare @a nvarchar(max) = substring(dbo.QBM_FSQColumDef(@TableName, @ColumnName), len(@columnname4) +2 , 256) select @erg = CONCAT( 'exec QBM_PColumnAdd ''' , @TableName , ''', ''', @ColumnName, ''', ''', @a , '''' )    return(@erg) end 5