insert values to a TABLE with columns with NULL

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  November 9, 2006 at 8:58 pm

  #116184

  I have a TABLE with unique id's and values.

  But i have some NULL values in 2 of the columns

  What is the best way to insert values into the NULL columns

  THese 2 columns have all NULLS in them.

  And i want to replace them with current year and current month

• Patrick.I

  Hall of Fame

  Points: 3105

  More actions

  November 9, 2006 at 9:12 pm

  #670981

  fixed my brain was asleep

• ChiragNS

  One Orange Chip

  Points: 26137

  More actions

  November 9, 2006 at 9:18 pm

  #670982

  dont know if i have understood ur problem correctly but this what i have to say.....

  This will update column1 with current year and column2 with current month where ever column1 or column2 have null values.

  update Table1 SET column1 = year(getdate()) columns1 IS NULL

  update Table1 SET column2 = year(getdate()) where  columns2 IS NULL.

   

  "Keep Trying"