Default values

[fiber0pti]

I added a field to one of my exsisting tables. I put a default value on it but it still has <NULL> for the value. How do I put this default value you in all of my records without having to do it manually?

 

[redlam]

make the column 'NOT NULL' then SQL should automatically insert the default value when a value is not supplied

 

[tlbroadbent]

And to update the Null column to the default value, just run a query like this.

Update Tbl Set ColA=defaulval
Where ColA is null Terry

;-) He has the right to criticize who has the heart to help. -Abraham Lincoln

SQL Article links:

http://members.home.net/tlbroadbent/sqlarticles.htm