Insert data into columns with value "NULL" in SQL server

Vote count: 0

I added additional columns to my "Customer" table without giving them a value. Now I'm trying to add data into those columns containing "NULL" as the default. I have tried using "select Account_Number,ISNULL(Employer,'Some Company')AS Employer from Customer" and "update Customer set Employer='Some Company' where Account_Number = '123456'" but nothing happens. How can i avoid having to use "Edit Top 200 Rows" to do this?

asked 37 secs ago

thatdude

Let's block ads! (Why?)

Insert data into columns with value "NULL" in SQL server