>>Hi All -
>>
>>I need to update a specific row within a table something like this:
>>
>>UPDATE mytable SET myfield = 10 WHERE (ROWNUMBER = 4)
>>
>>but I can't find a good way to identify the row. I've looked at ROW_NUMBER(), IDENTITY(), and RANK(), but none of them seem to fit. Could someone explain how to do this?
>>
>>Thanks
>
>In every table you have in SQL Server you must have primary key defined. That is mandatory :-)
>Then everything is easy.
To support your statement check this blog post
Best Practice: Every table should have a primary key
If it's not broken, fix it until it is.
My Blog