摘要:
sql server里面sql语句执行update,delete操作的时候,对表用别名的写法: update a set a.name=b.StuName from table1 a inner join table2 b on a.id=b.id; delete t from table1 t w 阅读全文
posted @ 2012-03-28 16:18 老K的幸福生活 阅读(692) 评论(0) 推荐(0)
|
|||
|
摘要:
sql server里面sql语句执行update,delete操作的时候,对表用别名的写法: update a set a.name=b.StuName from table1 a inner join table2 b on a.id=b.id; delete t from table1 t w 阅读全文
posted @ 2012-03-28 16:18 老K的幸福生活 阅读(692) 评论(0) 推荐(0) |
|||