第547章解决【中】 (2 / 9)
         return

         case

         when @type_id in (106, 108) -- fixed point numbers

         then quotename(@type_name) + '(' + convert(nvarchar(10), @precision) + ',' + convert(nvarchar(10), @scale) + ')'

         when @type_id in (62) -- floating point numbers where width can be specified

         then quotename(@type_name) + '(' + convert(nvarchar(10), @precision) + ')'

         when @type_id = 173 -- binary

         then quotename(@type_name) + '(' + convert(nvarchar(10), @max_length) + ')'

         when @type_id = 165 -- varbinary

         then quotename(@type_name) + '(' + case @max_length when -1 then 'max' else convert(nvarchar(10), @max_length) end + ')'

         when @type_id in (167, 175) -- ascii char

         then quotename(@type_name) + '(' + case @max_length when -1 then 'max' else convert(nvarchar(10), @max_length) end + ') COLLATE ' + @collation_name

         when @type_id in (231, 239) -- unicode char

         then quotename(@type_name) + '(' + case @max_length when -1 then 'max' else convert(nvarchar(10), @max_length / 2) end + ') COLLATE ' + @collation_name

  The content is not finished, continue reading on the next page

更多完整内容阅读登陆

《墨缘文学网，https://wap.mywenxue.org》