Back to OIM Explorer

dbo.QBM_FCVLimitedValueToDisplay

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

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

  • No direct source references extracted.

Complete Source

SQL21 lines
1CREATE FUNCTION dbo.QBM_FCVLimitedValueToDisplay(2  @InString nvarchar(256),3  @TableName varchar(30),4  @ColumnName varchar(30)5) RETURNS nvarchar(10246)7AS8BEGIN9  RETURN(10  SELECT TOP 1 isnull(11  LEFT(l.KeyDisplay, 1024), @InString)12  FROM dbo.DialogColumn c13    WITH(readpast)14  JOIN dbo.DialogTable t15    WITH(readpast)16    ON c.UID_DialogTable = t.UID_DialogTable17  JOIN dbo.QBMColumnLimitedValue l18    ON l.UID_DialogColumn = c.UID_DialogColumn19  WHERE20    c.ColumnName = @ColumnName AND t.TableName = @TableName AND c.HasLimitedValues = 1 AND l.KeyValue = @InString)21END
Open raw exported source
SQL ยท Raw5 lines
1  create   function dbo.QBM_FCVLimitedValueToDisplay(@InString nvarchar(256)  , @TableName varchar(30) , @ColumnName varchar(30) ) returns nvarchar2(1024)    as begin return( select top 1 isnull(left(l.KeyDisplay, 1024), @InString) from dbo.DialogColumn c with (readpast) join dbo.DialogTable t with3 (readpast) on c.UID_DialogTable = t.UID_DialogTable join dbo.QBMColumnLimitedValue l on l.UID_DialogColumn = c.UID_DialogColumn where c.ColumnName = @ColumnName4 and t.TableName = @TableName and c.HasLimitedValues = 1 and l.KeyValue = @InString ) end 5