文章分类 -  SQL

Insert Into select与Update select
摘要：insert into<TableName1> (<column1>,<column2>) select<column1>,<column2> from<TableName2> where column1=1update <TableName1> set <column1>= (select (<column1>) from <TableName2> where TableName1.<column2> =TableName2.<column2>) 阅读全文
posted @ 2013-04-15 11:52 Blue Studio 阅读(164) 评论(0) 推荐(0)