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_VER]  ,
[CREATE_USER] ,
[CREATETIME] ,
[UPDATE_USER]  ,
[UPDATETIME] ,
[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_VER]  ,
[CREATE_USER] ,
[CREATETIME] ,
[UPDATE_USER]  ,
[UPDATETIME] ,
[INDU_TYPE]) SELECT 
[INDU_CODE]  ,
[INDU_VER]  ,
[CREATE_USER] ,
[CREATETIME] ,
[UPDATE_USER]  ,
[UPDATETIME] ,
[INDU_TYPE]
FROM t_test_1;