<div>
Hi Vitor<br />
<br />
I right-clicked on the table, selected Design and that's what it told me it was.<br />
<br />
Thanks<br />
Sarah
</div>


Hi Vitor

I right-clicked on the table, selected Design and that's what it told me it was.

Thanks
Sarah

<div>
Wow! &nbsp;You're right. &nbsp;Thanks. &nbsp;I changed it to 25 and it's now creating as a float. &nbsp;That's really weird! &nbsp;You don't always need a length of 25 when you create a float field.
</div>


Wow!  You're right.  Thanks.  I changed it to 25 and it's now creating as a float.  That's really weird!  You don't always need a length of 25 when you create a float field.

<div>
The default is 53! :O<br />
Anyway if you need to store money values you have <b>money</b> and <b>smallmoney</b> data types.
</div>


The default is 53! :O
Anyway if you need to store money values you have money and smallmoney data types.

<div>
<blockquote>
The ISO synonym for real is float(24).
</blockquote>
<a href="https://msdn.microsoft.com/en-AU/library/ms173773.aspx" rel="ugc">https://msdn.microsoft.com/en-AU/library/ms173773.aspx</a><br />
<br />
i.e. It was already a &quot;Float&quot; but called a &quot;Real&quot; (confusing? yes, but I didn't make it that way)
</div>


> The ISO synonym for real is float(24).

https://msdn.microsoft.com/en-AU/library/ms173773.aspx [https://msdn.microsoft.com/en-AU/library/ms173773.aspx]

i.e. It was already a "Float" but called a "Real" (confusing? yes, but I didn't make it that way)

<div>
<div class="content wysiwyg-content">
Hi<br />
<br />
This is really annoying me! &nbsp;I have 2 lines which state:<br />
<br />
ALTER TABLE ROSS_LIVE ADD Net_Amount float (20) default (0) NOT NULL;<br />
GO<br />
<br />
It creates the column but as a real, not a float. &nbsp;Could someone please tell me what I'm doing wrong? &nbsp;I've copied the code for another project/query I wrote and that one doesn't give me any problems.<br />
<br />
I'm awarding 500 points for a quick and working solution.<br />
<br />
Thanks<br />
Sarah
</div>
</div>


Hi

This is really annoying me!  I have 2 lines which state:

ALTER TABLE ROSS_LIVE ADD Net_Amount float (20) default (0) NOT NULL;
GO

It creates the column but as a real, not a float.  Could someone please tell me what I'm doing wrong?  I've copied the code for another project/query I wrote and that one doesn't give me any problems.

I'm awarding 500 points for a quick and working solution.

Thanks
Sarah

MS SQL 2012 Add Column as Float Adds it as Real

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.