Back to OIM Explorer

dbo.QBM_FSQColumnCollationClause

Scalar FunctionSQL_SCALAR_FUNCTIONSandbox DB

Scalar Function.

Source: sandbox-db sys.sql_modules

Source size: 971 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_FGIColumnDataType source text reference

References

Referenced By

Complete Source

SQL32 lines
1CREATE FUNCTION dbo.QBM_FSQColumnCollationClause(2  @TableName varchar(30),3  @columnname varchar(30)4) RETURNS nvarchar(645)6AS7BEGIN8  DECLARE @SchemaDataType nvarchar(64)9  DECLARE @erg nvarchar(256) = N ' Collate  SQL_Latin1_General_CP1_CS_AS'10  SELECT11    @SchemaDataType = dbo.QBM_FGIColumnDataType(@TableName,12    @columnname)13  IF @SchemaDataType NOT LIKE '%char%'14  BEGIN15    SELECT @erg = N ''16    GOTO ende17  END18  IF EXISTS(19    SELECT TOP 1 120    FROM(21  VALUES('DialogMultiLanguage', 'EntryValue'),('DialogCountry', 'NationalCountryName'),('DialogCountry',22  'NationalCapitalName'),('DialogState', 'NationalStateName'),('DialogState', 'NationalCapitalName'),('QBMCulture',23  'NativeName'),('DialogCountryHoliday', 'NationalHolidayName'),('DialogStateHoliday', 'NationalHolidayName')) AS v(TableName,24  ColumnName)25  WHERE26    v.TableName = @TableName AND v.ColumnName = @columnname)27  BEGIN28    SELECT @erg = N ' Collate  latin1_general_bin'29  END30  ende:31  RETURN(@erg)32END
Open raw exported source
SQL ยท Raw8 lines
1    create   function dbo.QBM_FSQColumnCollationClause(@TableName varchar(30) , @columnname varchar(30) ) returns nvarchar(64) as begin declare 2@SchemaDataType nvarchar(64)  declare @erg nvarchar(256) = N' Collate  SQL_Latin1_General_CP1_CS_AS'   select @SchemaDataType = dbo.QBM_FGIColumnDataType3(@TableName , @columnname) if @SchemaDataType not like '%char%' begin select @erg = N'' goto ende end         if exists ( select top 1 1 from ( values 4('DialogMultiLanguage' , 'EntryValue') , ('DialogCountry', 'NationalCountryName') , ('DialogCountry', 'NationalCapitalName') , ('DialogState', 'NationalStateName'5) , ('DialogState', 'NationalCapitalName') , ('QBMCulture', 'NativeName') , ('DialogCountryHoliday', 'NationalHolidayName') , ('DialogStateHoliday', 'NationalHolidayName'6) ) as v (TableName, ColumnName) where v.TableName = @TableName and v.ColumnName = @columnname ) begin select @erg = N' Collate  latin1_general_bin'  end7 ende: return(@erg) end 8