要指定ClinetLink_ID字段的值,如INSERT INTO T_ClientLink
(Office_Tel, House_Tel, Fax, Email,Mobile_Tel,Client_ID,MainLink, ClinetLink_ID)
SELECT Telone, Teltwo, Fax, Email,Mobile_Tel,Client_ID,1, 1
FROM T_Client
WHERE (Telone is not null)
(Office_Tel, House_Tel, Fax, Email,Mobile_Tel,Client_ID,MainLink, ClinetLink_ID)
SELECT Telone, Teltwo, Fax, Email,Mobile_Tel,Client_ID,1, 1
FROM T_Client
WHERE (Telone is not null)
INSERT INTO T_ClientLink
(Office_Tel, House_Tel, Fax, Email,Mobile_Tel,Client_ID,MainLink)
SELECT Telone, Teltwo, Fax, Email,Mobile_Tel,Client_ID,1
FROM T_Client
WHERE (Telone is not null)set identity_insert off
(Office_Tel, House_Tel, Fax, Email,Mobile_Tel,Client_ID,MainLink, Clinet_Link_ID)
SELECT Telone, Teltwo, Fax, Email,Mobile_Tel,Client_ID,1, 1 AS Clinet_Link_ID
FROM T_Client
WHERE (Telone is not null)
INSERT INTO T_ClientLink
(Office_Tel, House_Tel, Fax, Email,Mobile_Tel,Client_ID,MainLink)
SELECT Telone, Teltwo, Fax, Email,Mobile_Tel,Client_ID,1
FROM T_Client
WHERE (Telone is not null)set identity_insert T_ClientLink off