I'm not sure if this is the place for this question, but here goes.
I am running SQL Server 2005, and I've encountered an issue with view data types. I had a client who asked if they could allow for decimals in a field that was previously an integer. This meant going and changing the column data type on a few
tables from integer to float, and changing some parameters and variables within some stored procs/functions to floats. Somewhere the value is still being rounded down, so I queried the information_schema.columns and found about 60 views in the system
that reference that column and are still being considered an int, from the tables which were already converted to float. I've found that if I simply script the views as alter and run it the column no longer is considered an int in the information schema.
My question is this: Does this seem to be my problem, that when the view is referenced the value is changed to an int? Or does the view simply reflect the table's data type and the information schema is incorrect? If the former, is there a faster way
to update all these views without going one by one and scripting them? Thanks in advance.
View Complete Post