2014年4月16日

摘要： --表之间数据复制SELECT* INTO yozhu FROM yo --复制一份表SELECT* INTO yozhu1 FROM yo where 11 --只复制表结构，无数据SELECT TOP 0 * into yozhu2 FROM yo --只复制表结构，无数据insert into yo(yoName) select yoName from yo--把本表复制一遍insert into pubs.dbo.yo select yoName from dbo.yo --数据库之间的表复制SELECT * FROM pubs.dbo.yoSELECT * FROM yo--嵌套查询 阅读全文

摘要： --表之间数据复制 SELECT* INTO yozhu FROM yo --复制一份表 SELECT* INTO yozhu1 FROM yo where 11 --只复制表结构，无数据 SELECT TOP 0 * into yozhu2 FROM yo... 阅读全文