摘要:
--表之间数据复制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--嵌套查询 阅读全文
posted @ 2014-04-16 15:49
Kevin Gao
阅读(593)评论(0)推荐(0)
编辑