v1.1.75
Download the SQL CLR here
- UPDATED: Monthly Trial Release
- ADDED:
DefaultNumberType
method to allow to add a default number type when no suffix is specified
DECLARE @sqlnet SQLNET
SET @sqlnet = SQLNET::New('5/100').DefaultNumberType('double');
SELECT @sqlnet.Eval() -- return 0.05 instead of 0
-- Valid value:
-- 'none' -- default
-- 'int'
-- 'uint'
-- 'long'
-- 'ulong'
-- 'float'
-- 'decimal'
-- 'double'
Trial unlocked until the end of January