MSSQL将查询结果写入到新的数据表中,并自动创建表
select * into tb_Test_Temp from Member
http://www.cnblogs.com/ylbtech/tag/SQLServer/
将MyStudentInfo表的所有字段数据插入不存在的表
SELECT
*
INTO
studentinfo_test1
FROM
MyStudentInfo
将MyStudentInfo表的个别字段数据插入不存在的表
SELECT
Id,
Name
INTO
MytestInfo
FROM
myStudentInfo
从一个以上的表中选取数据插入新表
SELECT
s.Id,s.
Name
,s.GradeId,g.GradeName
INTO
NewTable
FROM
MyStudentInfo s
INNER
JOIN
GradeInfo g
on
s.GradeId=g.Id
将MyStudentInfo表的id,name列插入studentinfo_test2(studentinfo_test2表已经存在)
INSERT
INTO
studentinfo_test2
SELECT
*
FROM
MyStudentInfo
https://www.jb51.net/article/238429.htm