How to change column datatype in SQL Server database without losing data?

by

You can easily do this using the following command. Any value of 0 will be turned into a 0 (BIT = false), anything else will be turned into 1 (BIT = true).

ALTER TABLE dbo.YourTable
   ALTER COLUMN YourColumnName BIT

The other option would be to create a new column of type BIT, fill it from the old column, and once you’re done, drop the old column and rename the new one to the old name. That way, if something during the conversion goes wrong, you can always go back since you still have all the data..

More Related Contents:

  1. How to split a comma-separated value to columns
  2. Using T-SQL, return nth delimited element from a string
  3. How to get a float result by dividing two integer values using T-SQL?
  4. Get first day of week in SQL Server
  5. SQL Server add auto increment primary key to existing table
  6. How to delete large data of table in SQL without log?
  7. Confused about UPDLOCK, HOLDLOCK
  8. Retrieve column definition for stored procedure result set
  9. Change Notification with Sql Server 2008
  10. Do while loop in SQL Server 2008
  11. Query times out when executed from web, but super-fast when executed from SSMS
  12. TSQL: How to convert local time to UTC? (SQL Server 2008)
  13. Regular Expressions in SQL Server servers?
  14. Unique constraint on multiple columns
  15. An attempt was made to access a socket in a way forbidden by its access permissions
  16. Transpose rows and columns with no aggregate
  17. How to find the port for MS SQL Server 2008?
  18. How to convert number of minutes to hh:mm format in TSQL?
  19. SQL Server Configuration Manager cannot be found
  20. SQL Server recursive query
  21. Temporarily disable all foreign key constraints
  22. How do I move a table into a schema in T-SQL
  23. nvarchar(max) vs NText
  24. How to display two digits after decimal point in SQL Server
  25. How to wait for 2 seconds?
  26. What are row, page and table locks? And when they are acquired?
  27. Error converting data types when importing from Excel to SQL Server 2008
  28. CHECKSUM and CHECKSUM_AGG: What’s the algorithm?
  29. SQL Server 2008 Spatial: find a point in polygon
  30. Implementing one-to-zero-or-one relation in SQL Server

Leave a Comment