sqlserver select into from
来源:互联网 发布:linux基础教程第三版 编辑:程序博客网 时间:2024/05/17 05:17
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 为2UPDATE 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为3UPDATE 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;
0 0
- sqlserver select into from
- sqlserver insert into select......into... from
- select into from 和 into from select
- select into from …
- insert into select from
- insert into select from
- SELECT INTO FROM语句
- Insert into select 和 select into from
- SELECT INTO FROM 与 INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- SELECT INTO FROM与INSERT INTO SELECT
- insert into from与select into from
- insert into from与select into from
- insert into select from 与 select into from
- 查看ubuntu上已安装软件
- 6、VTK基本数据结构
- jsp页面访问时总是包NullPointException
- web之HTML5----邮箱附件上传
- 如何查看容器的IP地址和网络相关的参数?
- sqlserver select into from
- Oracle Coherence中文教程六:Coherence集群简介
- Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestam
- Xcode6 pch文件问题
- 公共技术之 Java反射 Reflection
- 修改/etc/resolv.conf又恢复到原来的状态?
- not exists不等于not in
- Oracle Coherence中文教程七:设置群集
- libuv程序,捕获Ctrl+C事件