Back to OIM Explorer

dbo.QBM_FTHexPattern

Inline Table FunctionSQL_INLINE_TABLE_VALUED_FUNCTIONSandbox DB

Inline Table Function.

Source: sandbox-db sys.sql_modules

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

SQL30 lines
1CREATE FUNCTION dbo.QBM_FTHexPattern(2  @CountDigits int3) RETURNS TABLE4  WITH SCHEMABINDING5AS6RETURN(7  WITH einer(zeichen) AS(8SELECT a.z9FROM(10VALUES('0'),('1'),('2'),('3'),('4'),('5'),('6'),('7'),('8'),('9'),('A'),('B'),('C'),('D'),('E'),('F'),11('[^0-F]')) AS a(z))12SELECT13  CONCAT(e1.zeichen, e2.zeichen, e3.zeichen, e4.zeichen, e5.zeichen, '%') AS HexPattern14FROM einer e115LEFT16OUTER17JOIN einer e218  ON @CountDigits > 119LEFT20OUTER21JOIN einer e322  ON @CountDigits > 223LEFT24OUTER25JOIN einer e426  ON @CountDigits > 327LEFT28OUTER29JOIN einer e530  ON @CountDigits > 4)
Open raw exported source
SQL ยท Raw5 lines
1create function dbo.QBM_FTHexPattern(@CountDigits int) returns table with SCHEMABINDING as return( with einer(zeichen) as ( select a.z from ( values ('0'2) , ('1') , ('2') , ('3') , ('4') , ('5') , ('6') , ('7') , ('8') , ('9') , ('A') , ('B') , ('C') , ('D') , ('E') , ('F') , ('[^0-F]')  ) as a (z) ) select3 concat(e1.zeichen , e2.zeichen, e3.zeichen, e4.zeichen, e5.zeichen  , '%') as HexPattern from einer e1 left outer join einer e2 on @CountDigits > 1  left4 outer join einer e3 on @CountDigits > 2  left outer join einer e4 on @CountDigits > 3  left outer join einer e5 on @CountDigits > 4    )  5