sqlserver : Update First N Record

Update First N Record

ต้องการ update 10 Record แรก


WITH First10Rows AS
(
  SELECT TOP 10 Col1,Col2,Col3,...
  FROM MyTable
  WHERE Col..= .....
  ORDER BY SomeDateColumn
)
UPDATE First10Rows
SET Col1=..., Col2=...