复制表的SQL语句出错

Question

SELECT NEWID(),[danwei],[ren],[photo],[tel],[dizhi],[names],[gongd],[yi],[bian],[email],[time]
INTO BookShop.dbo.T_NET_Expert(ID,CompanyName,ContactName,OfficeTel,UserMobile,CompanyAddress,ProjectName,
ProjectAddress,HYDZ,PostCode,UserEmail,SBSJ)
FROM [myTest].[dbo].[shenbao]这个SQL语句哪错了啊？提示
消息 102，级别 15，状态 1，第 2 行
'ID' 附近有语法错误。

Answer 1

INSERT INTO BookShop.dbo.T_NET_Expert(ID,CompanyName,ContactName,OfficeTel,UserMobile,CompanyAddress,ProjectName,
ProjectAddress,HYDZ,PostCode,UserEmail,SBSJ)
SELECT NEWID(),[danwei],[ren],[photo],[tel],[dizhi],[names],[gongd],[yi],[bian],[email],[time]
FROM [myTest].[dbo].[shenbao]
语法是这样的

Answer 2

如果BookShop.dbo.T_NET_Expert没有建立SELECT NEWID() AS ID,[danwei] AS CompanyName,[ren] AS ContactName
,[photo],[tel],[dizhi],[names],[gongd],[yi],[bian],[email],[time]  --这里的AS 字段名自己修改下
INTO BookShop.dbo.T_NET_Expert
FROM [myTest].[dbo].[shenbao]

Answer 3

SELECT NEWID() AS ID,[danwei] AS CompanyName,[ren] AS ContactName,[photo] AS OfficeTel,[tel] AS UserMobile,[dizhi] AS CompanyAddress,
[names] AS ProjectName,[gongd]AS ProjectAddress,[yi] AS HYDZ,[bian]AS PostCode,[email] AS UserEmail,[time] AS SBSJ
INTO BookShop.dbo.T_NET_Expert
ProjectAddress,HYDZ,PostCode,UserEmail,SBSJ)
FROM [myTest].[dbo].[shenbao]

Answer 4

select ... into ... from ...前后字段要一一对应

Answer 5

SELECT
 NEWID() AS ID,[danwei] AS CompanyName,[ren] AS ContactName,
 [photo] AS OfficeTel,[tel] AS UserMobile,[dizhi] AS CompanyAddress,
 [names] AS ProjectName,[gongd]AS ProjectAddress,
 [yi] AS HYDZ,[bian]AS PostCode,[email] AS UserEmail,[time] AS SBSJ
INTO
 BookShop.dbo.T_NET_Expert
FROM
 [myTest].[dbo].[shenbao]

Answer 6

select * into 表1 from 表2是针对表1还没有创建使用的。
如果表1已经创建，应该insert into 表1 (字段列表) select * from 表2。

Answer 7

SELECT id=NEWID(),[danwei],[ren],[photo],[tel],[dizhi],[names],[gongd],[yi],[bian],[email],[time]
INTO BookShop.dbo.T_NET_Expert
FROM [myTest].[dbo].[shenbao]

Answer 8

SELECT NEWID(),[danwei],[ren],[photo],[tel],[dizhi],[names],[gongd],[yi],[bian],[email],[time]
INTO BookShop.dbo.T_NET_Expert(ID,CompanyName,ContactName,OfficeTel,UserMobile,CompanyAddress,ProjectName,
ProjectAddress,HYDZ,PostCode,UserEmail,SBSJ)
FROM [myTest].[dbo].[shenbao]