UPDATE

ALWAYS TYPE WHERE FIRST!

You should always do the following

  • Test the where with a select
  • Use transactions
  • Select the result before committing the transaction

UPDATE SchemaName.TableName
	 SET colName = 10,
			 colName2 = 11
 WHERE Id = 10