I am trying to update only the first 10 rows of a table. I am using the statement:
However, when this runs it updates all the rows in the table. What am I doing wrong?Code:UPDATE Incoming SET ID='2' FROM (SELECT Top 10 * FROM Incoming) AS t1 WHERE t1.ID='1'
Thanks!!




Reply With Quote