dbo.QBM_FCVSchemaDatatypeToIntern

1    create   function dbo.QBM_FCVSchemaDatatypeToIntern (@SchemaDatatype nvarchar(256), @SchemaMaxLen int ) returns int with SCHEMABINDING as begin
2 declare @erg int select @erg = 7 if isnull(sign(@SchemaMaxLen),0) = -1 begin if @SchemaDatatype = 'varbinary' begin select @erg = 7  end else begin select
3 @erg = 10  end  return(@erg)  end select @erg = case @SchemaDatatype when 'Binary' then 7  when 'bit' then 0  when 'char' then 6  when 'datetime' then
4 5  when 'decimal' then 4  when 'float' then 3  when 'image' then 7  when 'int' then 1  when 'bigint' then 2  when 'money' then 4  when 'nchar' then 6 
5 when 'ntext' then 6  when 'numeric' then 4  when 'varchar' then 6  when 'real' then 3  when 'smalldatetime' then 5  when 'smallint' then 1  when 'smallmoney'
6 then 4  when 'text' then 10  when 'timestamp' then 7  when 'tinyint' then 1  when 'uniqueidentifier' then 7  when 'varbinary' then 7  when 'nvarchar' 
7then 6  else 7 end endLabel: return(@erg) end 
8