Select the effected table for example salestable, one field in changed from int to real.
After changing the filed we may get an errors cannot convert from int to Real.
Solution:
Go to Data base execute the below queries.
select * from salestable.// Check the data
select * into salestable_copy from salesTable. // This will copy the data from Salestable to salestable_copy
sp_removable salestable // this will delete the table from entire data base.
select * into salesTable from salestable_copy //This will copy the data from salestable_copy to Salestable
Now we can delete the copy table as shown below.
sp_removable salestable_copy
sp_helptext salesTable // For stored procedure query.
After changing the filed we may get an errors cannot convert from int to Real.
Solution:
Go to Data base execute the below queries.
select * from salestable.// Check the data
select * into salestable_copy from salesTable. // This will copy the data from Salestable to salestable_copy
sp_removable salestable // this will delete the table from entire data base.
select * into salesTable from salestable_copy //This will copy the data from salestable_copy to Salestable
Now we can delete the copy table as shown below.
sp_removable salestable_copy
sp_helptext salesTable // For stored procedure query.
No comments:
Post a Comment