Altering a column: null to not null

by

First, make all current NULL values disappear:

UPDATE [Table] SET [Column]=0 WHERE [Column] IS NULL

Then, update the table definition to disallow “NULLs”:

ALTER TABLE [Table] ALTER COLUMN [Column] INTEGER NOT NULL

More Related Contents:

  1. How much size “Null” value takes in SQL Server
  2. How do you change the datatype of a column in SQL Server?
  3. SQL Server – error when creating stored procedure
  4. NULL values inside NOT IN clause
  5. Not equal != operator on NULL
  6. How can foreign key constraints be temporarily disabled using T-SQL?
  7. Insert multiple rows WITHOUT repeating the “INSERT INTO …” part of the statement?
  8. Does T-SQL have an aggregate function to concatenate strings? [duplicate]
  9. Parameter Sniffing (or Spoofing) in SQL Server
  10. SQL Server String or binary data would be truncated
  11. How to change identity column values programmatically?
  12. SQL Server Regular expressions in T-SQL
  13. How to get a date in YYYY-MM-DD format from a TSQL datetime field?
  14. How do I format a number with commas in T-SQL?
  15. Concatenating Column Values into a Comma-Separated List
  16. Find index of last occurrence of a sub-string using T-SQL
  17. SQL Server 2008 Empty String vs. Space
  18. How to set a default value for an existing column
  19. Need a datetime column in SQL Server that automatically updates when the record is modified
  20. How do I find a stored procedure containing ?
  21. Query to list all stored procedures
  22. WHERE clause on SQL Server “Text” data type
  23. Get ROWS as COLUMNS (SQL Server dynamic PIVOT query)
  24. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  25. Check if a string contains a substring in SQL Server 2005, using a stored procedure
  26. Cannot bulk load. Operating system error code 5 (Access is denied.)
  27. Does query plan optimizer works well with joined/filtered table-valued functions?
  28. Is there an “IF EXISTS” test for a linked server?
  29. ADO.NET calling T-SQL Stored Procedure causes a SqlTimeoutException
  30. SQL Server stored procedure return code oddity

Leave a Comment