sql 2000 中語法如何把指標移到最後一筆並修改內容 堅持從洗馬桶做起 Eric

Hi huangeider,    何謂最後一筆資料？    假設 ID 為 Table 的主索引鍵，且為唯一值

update  table
set     field1 = value1,
        field2 = value2,
        .....
where   id = (select max(id) from table)

---------------------------------- 小弟才疏學淺，若有謬誤尚請不吝指教 ----------------------------------

------
Fishman

Declare CUR_EMP Cursor Dynamic For Select * From Employees For Update --宣告 Open CUR_EMP FETCH LAST FROM CUR_EMP --移動 Update Employees Set LastName=LastName '-' Where Current Of CUR_EMP --更新 Close CUR_EMP --關閉 Deallocate CUR_EMP --解除