可以执行么?
Try:
INSERT INTO WHNEC.TBLCS_SalesDepartment(FDSALESCODE, FDSALESNAME, FDPROVINCE, FDREGION, FDADDRESS, FDPOST, FDCONTACT, FDTELEPHONE, FDMOBILE, FDFAX, FDEMAIL, FDDEGREE, FDREMARK) select '0002','11',(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '北京' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0001'),(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '华东' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0002'),'','','','','','','',(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '受理中心' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0003'),''
Try:
INSERT INTO WHNEC.TBLCS_SalesDepartment(FDSALESCODE, FDSALESNAME, FDPROVINCE, FDREGION, FDADDRESS, FDPOST, FDCONTACT, FDTELEPHONE, FDMOBILE, FDFAX, FDEMAIL, FDDEGREE, FDREMARK) select '0002','11',(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '北京' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0001'),(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '华东' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0002'),'','','','','','','',(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '受理中心' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0003'),''
FDSALESCODE, FDSALESNAME, FDPROVINCE, FDREGION,
FDADDRESS, FDPOST, FDCONTACT, FDTELEPHONE,
FDMOBILE, FDFAX, FDEMAIL, FDDEGREE, FDREMARK
)
select '0002','11',(
SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '北京'
AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0001'
),(
SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '华东'
AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0002'
),'','','','','','','',(
SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '受理中心'
AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0003'
),''
FDSALESCODE, FDSALESNAME, FDPROVINCE, FDREGION,
FDADDRESS, FDPOST, FDCONTACT, FDTELEPHONE,
FDMOBILE, FDFAX, FDEMAIL, FDDEGREE, FDREMARK
)
select '0002','11',(
SELECT min(WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 )
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '北京'
AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0001'
),(
SELECT min(WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 )
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '华东'
AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0002'
),'','','','','','','',(
SELECT min(WHNEC.TBLCS_GENERAL_MASTER.FDCODE2)
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '受理中心'
AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0003'
),''
select '0002','11',
(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '北京' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0001'),
(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '华东' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0002'),'','','','','','','',
(SELECT WHNEC.TBLCS_GENERAL_MASTER.FDCODE2 FROM WHNEC.TBLCS_GENERAL_MASTER WHERE WHNEC.TBLCS_GENERAL_MASTER.FDCONTENT = '受理中心' AND WHNEC.TBLCS_GENERAL_MASTER.FDCODE1 = '0003'),''
1:insert A select * from B;
zjcxc、giges(giges)等的都可以!
2:insert A values();
declare @code1 as char(4),@code2 as char(4),@code3 as char(4) --具体长度根据表结构SELECT @code1 =FDCODE2
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE FDCONTENT = '北京' AND FDCODE1 = '0001'SELECT @code2 =FDCODE2
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE FDCONTENT = '华东' AND FDCODE1 = '0002'
SELECT @code3= FDCODE2
FROM WHNEC.TBLCS_GENERAL_MASTER
WHERE FDCONTENT = '受理中心' AND FDCODE1 = '0003'INSERT INTO WHNEC.TBLCS_SalesDepartment
(FDSALESCODE, FDSALESNAME, FDPROVINCE, FDREGION, FDADDRESS, FDPOST, FDCONTACT, FDTELEPHONE, FDMOBILE, FDFAX, FDEMAIL, FDDEGREE, FDREMARK)
VALUES ('0002','11',@code1,@code2,'','','','','','','',@code3,'')