Back to OIM Explorer

dbo.QBM_FSQIndexDefCond

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 450 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_FSQIndexDef source text reference

References

Referenced By

  • No direct source references extracted.

Complete Source

SQL26 lines
1CREATE FUNCTION dbo.QBM_FSQIndexDefCond(2  @ObjectName nvarchar(64)3) RETURNS nvarchar(max4)5AS6BEGIN7  DECLARE @TableName nvarchar(64)8  DECLARE @IndexName 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    @Indexname = substring(@ObjectName,20    @posi+1,21    255)22  SELECT23    @erg = dbo.QBM_FSQIndexDef(@TableName,24    @Indexname)25  RETURN(@erg)26END
Open raw exported source
SQL · Raw4 lines
1  create   function dbo.QBM_FSQIndexDefCond (@ObjectName nvarchar(64)) returns nvarchar(max) as begin  declare @TableName nvarchar(64) declare @IndexName2 nvarchar(64) declare @Posi int declare @erg nvarchar(max) select @posi = charindex(N'.', @Objectname) select @TableName = substring(@ObjectName, 1, @posi-13) select @Indexname = substring(@ObjectName, @posi+1, 255) select @erg = dbo.QBM_FSQIndexDef(@TableName , @Indexname) return(@erg) end 4