SQL Server changing a float to a real

• katmeadows

  Right there with Babe

  Points: 790

  More actions

  September 18, 2003 at 1:41 pm

  #101674

  Does anyone know why when you run a script to create a table in SQL2000, it automatically changes your datatype from a float(8) to a real(4)?

  Example:

  create table Test( myfloat float(8))

  go

  Then if you run sp_columns test is shows

  Table_qualifier: XXX

  Table_Owner:dbo

  Table_Name:Test

  Column_Name:myfloat

  Data_Type: 7

  Type_Name: real

  Presision:7

  Length:4

  Thank,

  Kat

• ZenDada

  SSCarpal Tunnel

  Points: 4637

  More actions

  September 18, 2003 at 2:59 pm

  #474942

  take out the (8)

  drop table test

  go

  create table Test(myfloat float)

  go

  exec sp_columns test returns the float you expected.

  J. Moseley

  [font="Courier New"]ZenDada[/font]