title: SQL Server 2005 varchar loses decimal places converting to a decimal
body: <pre><code>Declare @BadDecimal varchar(5)
  Set @BadDecimal = '4.5'
  Declare @GoodDecimal Decimal
  Set @GoodDecimal = @BadDecimal
  Select @GoodDecimal
  
  --Outputs 5
  </code></pre>
  
  <p>Why?</p>