Back to OIM Explorer

dbo.QBM_FSQStringAsLiteral

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

SQL36 lines
1CREATE FUNCTION dbo.QBM_FSQStringAsLiteral(2  @in nvarchar(max),3  @MakeUnicodeString BIT,4  @ForIndirect BIT5) RETURNS nvarchar(max6)7  WITH SCHEMABINDING8AS9BEGIN10  DECLARE @erg nvarchar(max)11  SELECT12    @erg = N '''' + replace(@in,13    N '''',14    N '''''') + N ''''15  IF @MakeUnicodeString = 116  BEGIN17    SELECT @erg = N 'N' + @erg18  END19  ELSE20  BEGIN21    IF @in <> convert(nvarchar(max),22    convert(varchar(max), @in)) collate SQL_Latin1_General_CP1_CI_AS23    BEGIN24      SELECT @erg = N 'N' + @erg25    END26  END27  IF @ForIndirect = 128  BEGIN29    SELECT30      @erg = replace(@erg,31      N '''',32      N '''''')33  END34  ende:35  RETURN(@erg)36END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QBM_FSQStringAsLiteral(@in nvarchar(max)  , @MakeUnicodeString bit  , @ForIndirect bit  ) returns nvarchar(max) with SCHEMABINDING2 as begin declare @erg nvarchar(max) select @erg = N'''' + replace(@in, N'''', N'''''') + N'''' if @MakeUnicodeString = 1 begin select @erg = N'N' + @erg3 end else begin if @in <> convert(nvarchar(max), convert(varchar(max), @in)) collate SQL_Latin1_General_CP1_CI_AS  begin select @erg = N'N' + @erg end 4end if @ForIndirect = 1 begin select @erg = replace(@erg, N'''', N'''''') end ende: return (@erg) end 5