March 12, 2009 at 4:19 am
Hi,
I have a really simple problem. I have to modify a table. A column whiwh is int i have to convert it to float in SQL Server 2000. And i have some foreign keys in this table, so automatically i t willchange for the others alos. Will i have a problem with my data ?
thanks in advance.
March 12, 2009 at 5:56 am
A float type FK? Never seen that before. I'd say you would have more problems with any applications connecting to it then data issues. Just create another field in the table and try updating the int into the float and see how it turns out. Worst case, single user mode, kill the FK constaints, change tables and put it back together.
And make sure you test this on another sql server with the same version connecting your apps to it.
March 17, 2009 at 3:54 pm
Do this using query analyzer, it will only change the datatype for the table for which you will run ALTER statement.
MJ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply