title: Stored Procedure float input param truncating value
body: <p>I have a stored procedure that has input params:</p>
  
  <pre><code>  @Latitude float
  , @Longitude float
  </code></pre>
  
  <p>but when I pass these values:</p>
  
  <pre><code> @Latitude=-28.640328248358344
  ,@Longitude=153.61249352645871
  </code></pre>
  
  <p>the values being stored in the table are:</p>
  
  <pre><code>Lat: -28.6403
  Lng: 153.612
  </code></pre>
  
  <p>If I do a standard insert or update on the table the values are correct.</p>
  
  <p>I tried changing the params to float(54) but it made no difference... The reason I am using a float is because the Lat/Lng are actually computed cols from a geography column (and it states in the designer that they are floats) - I have double checked that it's not related to the computed cols by inserting the lat/lng values from the stored procedure into a couple of varchar columns.</p>
  
  <p>I am using EF and can confirm that the values are correct in the Entities and I have checked the SQL Profiler to confirm that the full values are included in the exec call.</p>
  
  <p>EDIT:
  I insert these values into a column call GeoLocation of type geography:</p>
  
  <pre><code>GeoLocation = geography::STPointFromText('POINT(' + CONVERT(varchar, @Longitude) + ' ' + CONVERT(varchar, @Latitude) + ')',4326)
  </code></pre>