Update Top 1 record in table sql server

The Solution to Update Top 1 record in table sql server is


WITH UpdateList_view AS (
  SELECT TOP 1  * from TX_Master_PCBA 
  WHERE SERIAL_NO IN ('0500030309') 
  ORDER BY TIMESTAMP2 DESC 
)

update UpdateList_view 
set TIMESTAMP2 = '2013-12-12 15:40:31.593'

~ Answered on 2014-11-26 09:36:46


Most Viewed Questions: