sql server - SQL converting columns times out -


I need a query that will change a column of up to 32 (max) to nerve (max). The actual problem is that this table contains 800,000 rows. And when changing my table, change my column statement. Any suggestions or suggestions?

It is possible to add a new column, then select the data in the new column and then the old column And the name of the new column will be changed to the original name.

According to the need for a more simple approach, a new table will be created with specifications and after this it has to be selected. After this, the old table can be removed.


Comments