从c#asp.net页更新sql数据库表的最后一行 [英] updating last row of sql database table from c# asp.net page

问题描述

大家好
m试图更新具有最高ID的sql表....有人可以帮我吗.

解决方案

假设您使用的是数字ID系统，则应执行以下操作工作:

  UPDATE  myTable  SET  myField = '  NewValue' 位置 iD =( SELECT  MAX(iD) FROM  myTable)

但是，请注意，如果这是多用户系统，则您不知道要更新的记录.

如果要使用它来更新您最近创建的记录，则可能不会发生！

UPDATE table_name 

SET cloumn_name = "Value"

WHERE id = (SELECT id FROM table_name ORDER BY id LIMIT 1,1)

UPDATE Table_Name SET Column_Name = ''Column_Value'' WHERE ID = @@Identity

hi guys
m trying to update sql table which has highest id.......can somebody help me.

解决方案

Assuming you use a numeric ID system, the following should work:

UPDATE myTable SET myField='NewValue' WHERE iD= (SELECT MAX(iD) FROM myTable)

However, be aware that if this is multi-user system, you do not know what record you are updating.

If you want to use this to update the record you recently created, that may not happen!

UPDATE table_name 

SET cloumn_name = "Value"

WHERE id = (SELECT id FROM table_name ORDER BY id LIMIT 1,1)

UPDATE Table_Name SET Column_Name = ''Column_Value'' WHERE ID = @@Identity

这篇关于从c#asp.net页更新sql数据库表的最后一行的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！