\"\" ORDER BY FBBANAME\" Need to update a table in ascending orderThis query is not complete. You can use inner SQL statement bas" />

开发者

vb.net access query for updating

开发者 https://www.devze.com 2023-01-23 23:41 出处：网络

is d query rite ? q = \"update FIRSTBBA 开发者_C百科WHERE FBBANAME<>\"\" ORDER BY FBBANAME\" Need to update a table in ascending orderThis query is not complete. You can use inner SQL statement bas

相关专题：

is d query rite ? q = "update FIRSTBBA 开发者_C百科WHERE FBBANAME<>"" ORDER BY FBBANAME" Need to update a table in ascending order

This query is not complete. You can use inner SQL statement based on your requirement and update the table based on that.

You're not assigning a value to FIRSTBBA. Also, not sure what database you're using but I don't think SQL server allows an order by clause in an update statement. you would have to refer to a post like this one: How to update and order by using ms-sql