Change type of a column with numbers from varchar to int

by

The only reliable way to do this will be using a temporary table, but it will not be much SQL:

select * into #tmp from bad_table
truncate table bad_table
alter bad_table alter column silly_column int
insert bad_table
select cast(silly_column as int), other_columns
from #tmp
drop table #tmp

More Related Contents:

  1. Should you choose the MONEY or DECIMAL(x,y) datatypes in SQL Server?
  2. Datatype for storing ip address in SQL Server
  3. Is there a Boolean data type in Microsoft SQL Server like there is in MySQL? [duplicate]
  4. Real vs. Floating Point vs. Money
  5. SSIS Excel Import Forcing Incorrect Column Type
  6. How to handle this scenario in single SSIS package?
  7. find 2nd highest salary in sql [closed]
  8. Update a table using JOIN in SQL Server?
  9. What is the difference between varchar and nvarchar?
  10. SQL Server CTE and recursion example
  11. Calculate running total / running balance
  12. Unexpected variable type returned by Receive-Job
  13. CTE Recursion to get tree hierarchy
  14. List of all index & index columns in SQL Server DB
  15. Why use a READ UNCOMMITTED isolation level?
  16. How much size “Null” value takes in SQL Server
  17. Using a sort order column in a database table
  18. How to remove the time portion of a datetime value (SQL Server)?
  19. SQL Server String Concatenation with Null
  20. Preserving ORDER BY in SELECT INTO
  21. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  22. How do I get date/time information from a TIMESTAMP column?
  23. What are the differences between a clustered and a non-clustered index?
  24. Unable to begin a distributed transaction
  25. Bulk insert with text qualifier in SQL Server
  26. How to migrate a PostgreSQL database into a SQLServer one?
  27. Multiple Column Pivot in T-SQL
  28. SSRS report definition is newer than Server
  29. How to check SQL Server Database compatibility after sp_dbcmptlevel is deprecated?
  30. SQL SERVER PIVOT table with joins and dynamic columns

Leave a Comment