A UPDATE statement

zhaozj2021-02-12  174

SQL version

Update Table Set Display = (Case When Display = -1 Then 0 when Display = 0 THEN -1 END)

Access version

Update Tablename Set Display = IIF (Display = 0, -1, 0)

This method can have a lot more trouble

转载请注明原文地址:https://www.9cbs.com/read-6624.html

New Post(0)