我有两个表,即,table1
与table2
具有相同的结构,我想表1中的所有值插入到表2。这些表包含两个图像类型列。我已经尝试过此查询,但无法成功。
DECLARE @imagepan VARBINARY(MAX)
DECLARE @imagecheque VARBINARY(MAX)
SET @imagepan=(SELECT panid FROM table1 WHERE Emp_code='E001')
SET @imagecheque=(SELECT cancel_checqe FROM table1 WHERE Emp_code='E001')
INSERT INTO table2
(transno, Emp_code, PanNo, panid, panext, entdt_pan, banknm,
cancel_checqe, chqExt, entDt_bnk, Acc_No, IFSC, Cheque_nm, status_pan1,
status_pan, status_bnk1, status_bnk, userid, entdt, panModify_by,
panModify_on, bnkModify_by, bnkModify_on)
VALUES
(SELECT
transno, Emp_code, PanNo, @imagepan, panext, entdt_pan,
banknm, @imagecheque, chqExt, entDt_bnk, Acc_No, IFSC, Cheque_nm,
status_pan1, status_pan, status_bnk1, status_bnk, userid, entdt,
panModify_by, panModify_on, bnkModify_by, bnkModify_on
FROM
table1
WHERE
Emp_code='E001')
我怎样才能做到这一点?
删除“值”关键字
insert into table2 (transno, Emp_code, PanNo, panid, panext, entdt_pan,
banknm, cancel_checqe, chqExt, entDt_bnk, Acc_No,
IFSC, Cheque_nm, status_pan1, status_pan,
status_bnk1, status_bnk, userid, entdt, panModify_by,
panModify_on, bnkModify_by, bnkModify_on)
select
transno, Emp_code, PanNo, @imagepan, panext, entdt_pan,
banknm, @imagecheque, chqExt, entDt_bnk, Acc_No,
IFSC, Cheque_nm, status_pan1, status_pan,
status_bnk1, status_bnk, userid, entdt, panModify_by,
panModify_on, bnkModify_by, bnkModify_on
from
table1
where
Emp_code = 'E001';
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句