sqlserver select into from

SELECT * FROM C_INDU_INFO;

--UPDATE C_INDU_INFO SET INDU_TYPE = '1';

-- 依据行业表创建临时表
SELECT * INTO t_test_1 FROM C_INDU_INFO;

SELECT * FROM t_test_1;

-- 更新type 为2
UPDATE t_test_1 SET indu_type = '2';

-- INSERT INTO tablename() SELECT fields .... FROM tableName;
INSERT INTO t_test_1(
[INDU_CODE],[INDU_VER],[CREATE_USER],[CREATETIME],[UPDATE_USER],[UPDATETIME],[INDU_TYPE]) SELECT 
[INDU_CODE],[INDU_TYPE]
FROM C_INDU_INFO;


-- 更新type 1为3
UPDATE t_test_1 SET indu_type = '3' WHERE indu_type = '1';

INSERT INTO C_INDU_INFO(
[INDU_CODE],[INDU_TYPE]
FROM t_test_1;

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!