UPDATE tab SET col1='XXX' WHERE col2='ZZZ'
UPDATE tab SET col1='XXX' FROM tab WHERE col2='ZZZ'
兩種寫法有什麼不同用處呢?
2016-12-13
SQL Server Update(Delete)的使用方法建議
- 698
- 0
- SQL Server
- 1
UPDATE tab SET col1='XXX' WHERE col2='ZZZ'
UPDATE tab SET col1='XXX' FROM tab WHERE col2='ZZZ'
兩種寫法有什麼不同用處呢?