摘要: Update中使用表别名select中的表别名:select * from TableA as taupdate中的表别名:update taset ta.key = 1from TableA as ta如何用表中一列值替换另一列的所有值不同表列替换:update taset ta.key1 = tb.key2from TableA as ta, TableB as tbwhere ta.key = tb.key同一表列替换:update taset ta.key1 = tb.key2from TableA as ta, TableA as tbwhere ta.key = tb.key 阅读全文
posted @ 2013-06-25 13:54 编程的厨子 阅读(3045) 评论(0) 推荐(0) 编辑