Reputation: 291
How to change data type of column in sql server if the column contain millions of rows?
I try this it should work.
alter table employee
alter column dob datetime
but I get an error.
That is - table contain huge amount of data or it is full you are not able to change data type.
Upvotes: 1
Views: 501
Reputation: 203
Please take following steps:
If you go this way, you can see, where the problem is:
Upvotes: 1