Back to OIM Explorer

dbo.QBM_FSQTableDefCond

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 482 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_FSQTableDef source text reference

References

Referenced By

Complete Source

SQL24 lines
1CREATE FUNCTION dbo.QBM_FSQTableDefCond(2  @TableName nvarchar(64)3) RETURNS nvarchar(max4)5AS6BEGIN7  DECLARE @erg nvarchar(max)8  DECLARE @muster nvarchar(max)9  SELECT10    @muster = ' 11 if not exists (select top 1 1 from Information_schema.tables with (readpast) where table_name = N''@TableName'')12  begin13	@create14  end'15  SELECT16    @erg = replace(@muster,17    N '@TableName',18    @TableName)19  SELECT20    @erg = replace(@erg,21    N '@create',22    dbo.QBM_FSQTableDef(@TableName))23  RETURN(@erg)24END
Open raw exported source
SQL ยท Raw9 lines
1    create   function dbo.QBM_FSQTableDefCond (@TableName nvarchar(64)) returns nvarchar(max) as begin declare @erg nvarchar(max) declare @muster2 nvarchar(max) select @muster = ' 3 if not exists (select top 1 1 from Information_schema.tables with (readpast) where table_name = N''@TableName'')4  begin5	@create6  end'7  select @erg = replace(@muster, N'@TableName', @TableName ) select @erg = replace (@erg, N'@create', dbo.QBM_FSQTableDef(@TableName )) return(@erg) end8 9