Back to OIM Explorer

dbo.QBM_FGISingleUserRunning

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL26 lines
1CREATE FUNCTION dbo.QBM_FGISingleUserRunning(2) RETURNS int3AS4BEGIN5  DECLARE @erg int = 06  DECLARE @me int7  SELECT8    TOP 1 @erg = isnull(d.SingleUserProcess,9    0)10  FROM dbo.DialogDatabase d11    WITH(nolock)12  WHERE13    d.IsMainDatabase = 114  IF @erg = 015  BEGIN16    RETURN(@erg)17  END18  SELECT @me = @@SPID19  IF @me = @erg20  BEGIN21    SELECT @erg = -122    RETURN(@erg)23  END24  SELECT @erg = 1 endLabel:25  RETURN(@erg)26END
Open raw exported source
SQL ยท Raw4 lines
1   create   function dbo.QBM_FGISingleUserRunning () returns int    as begin declare @erg int = 0 declare @me int select top 1 @erg = isnull(d.SingleUserProcess2, 0) from dbo.DialogDatabase d with (nolock) where d.IsMainDatabase = 1 if @erg = 0 begin  return(@erg)  end  select @me = @@SPID if @me = @erg begin select3 @erg = -1  return(@erg)  end  select @erg = 1 endLabel: return(@erg) end 4