How do you change the datatype of a column in SQL Server?

by 
ALTER TABLE TableName 
ALTER COLUMN ColumnName NVARCHAR(200) [NULL | NOT NULL]

EDIT
As noted NULL/NOT NULL should have been specified, see Rob’s answer as well.

More Related Contents:

  1. Altering a column: null to not null
  2. How to convert number of minutes to hh:mm format in TSQL?
  3. Max Nbr of Months W/ No Activity in Past 12 Months
  4. SQL server query to output the data shown below
  5. Will ANSI JOIN vs. non-ANSI JOIN queries perform differently?
  6. How do I generate a random number for each row in a T-SQL select?
  7. Combine multiple results in a subquery into a single comma-separated value
  8. How do you view ALL text from an ntext or nvarchar(max) in SSMS?
  9. Floor a date in SQL server
  10. How to drop a table if it exists?
  11. Create a view with ORDER BY clause
  12. What does ‘COLLATE SQL_Latin1_General_CP1_CI_AS’ do?
  13. INSERT INTO vs SELECT INTO
  14. Possible to store value of one select column and use it for the next one?
  15. How FOR XML PATH(”) works when concatenating rows
  16. Scheduled run of stored procedure on SQL server
  17. SQL Server ORDER BY date and nulls last
  18. SQL Server variable columns name?
  19. What is the Oracle equivalent of SQL Server’s IsNull() function?
  20. SQL Recursive CTE: Finding objects linked by property
  21. Use of Begin / End Blocks and the Go keyword in SQL Server?
  22. How do you determine what SQL Tables have an identity column programmatically
  23. Ampersand (&) operator in a SQL Server WHERE Clause
  24. Avg of float inconsistency
  25. how to write number to word function in sql server [closed]
  26. SQL Server error “Implicit conversion of because the collation of the value is unresolved due to a collation conflict.”
  27. SQL SERVER – Understanding how MIN(text) works
  28. Pivot multiple columns based on one column in SQL Server
  29. @@ERROR and/or TRY – CATCH
  30. How to calculate difference in hours (decimal) between two dates in SQL Server?

Leave a Comment