Scenario: In production we have the same functional DB at different physical sites. The column order on a table don't match each other so I am writing a script to amend this (a 3rd party application requirement).
Action: To do this I copied the table to a test server, made the changes required in the GUI and then used the save to script functionality. The generated script essentially creates a new table with the proper order, copies the data into there, deletes the original table and then renames the new table to the old/proper name.
Query: The generated table definition includes in part column definitions such as:
STAGE3 float(53) NULL
Using the more common Script Table as> Create to new query window the same column is generated as:
[STAGE3] [float] NULL
1) Why is there a difference?
2) Does it matter?
Environment:
Server SQL2000
SSMS 2008, Script for server version set to SQL Server 2000
Production destinations SQL2000, SQL2008, SQL2008R2