随笔-22  评论-42  文章-0  trackbacks-1

sql server多表关联update

UPDATE Tab1 SET a.Name = b.Name FROM Tab1 a,Tab2 b WHERE a.ID = b.ID
posted on 2005-11-11 11:06 David 阅读(5169) 评论(6) 编辑 收藏