sql server - MS SQL update Query, gotta be something simple -


I am trying to set the checklines for every line in blue in the table in tblCheckbook < / P> 

  UPDATE tblCheckbook SET CheckColor = Blue  
 I am using this query  code>  
 However, Microsoft SQL Server Management Studio Express invalid column name 'Blue' complains.  
 This should be a simple improvement, what am I doing?   
 
 
 Try this:  
  UPDATE tblCheckbook SET checker = 'Blue'

Comments

Post a Comment