I have a table in SQL Server 2000 that has several null-able integer columns. These are not working for me so I'm trying to update all nulls to 0 and then set the columns as "NOT NULL" (But the data must be preserved).
Is there a specific SQL Syntax that could set the columns this way?
October 8, 2013 6:21 PM
October 9, 2013 6:58 PM