insert into table from another table teradata

How to delete one piece of data and insert this data into another table Now there are two tables Sns_topic,sns_topic_del, on the list page of the Sns_topic table for editing operations, the need to delete a piece of data while inserting this data into the Sns_topic_del table, how to do? ------Solution----------------

From the Internet to find the method, but very good, recorded, but also to share the next ~ ~There is a table, city, with columns: cityid,cityname; change all data in this table to insert statementSelect ' Insert into TableName (cityid,cityname) VALUES (' ' +cityid+ ' ", ' +cityname+ ') ' as sqlstr from the city;So tha

Label: drop database if exists school; Delete if school is presentCREATE DATABASE School; Building a library schoolUse School; Open Library SchoolCREATE TABLE Teacher (//Build tables TeacherID int (3) auto_increment NOT NULL primary key,name Char (TEN) is not NULL,address varchar (+) Default ' Shenzhen ',Year date); End of Build table//Below is the Insert fieldIN

Data insert, modify, delete operations for 1.MySQL database tables SQL syntax format:1 CREATE DATABASEdb0504;2 3 Usedb0504;4 5 CREATE TABLEStudent (6SnoVARCHAR(Ten) not NULL UNIQUE PRIMARY KEY,7SnameVARCHAR( -) not NULL,8Ssex enum ('male','female') not NULL DEFAULT 'male',9 Sbirth Date,TenSclassVARCHAR(Ten), OneZnoCHAR(4) A)DEFAULTCharSet=gb2312; - #添加操作 - INSERT intoStudent the VALUES('2012010713','Ding

Tags: style blog http io color os ar sp dataPrevious: MFC links Access 2007 databaseThe next step is to say how to insert data into an Access 2007 database (the web looked under, said a little vague, directly to see the effect )Main steps:1 first generate SQL Statement 2 with sprintf and then execute the SQL statement.The effect is as follows:Main code:CString strconn,strdbname;//serv103_serv_link_acces (); if (m_pconnection->state) {m_precordset.crea

the operating system. For some reason, the speed may be slow. However, it seems that there is no reason to think about it again. After all, adding 10000 records also requires a space of 10000 records. The speed should not be affected. After all, ACCESS does not use any redo/undo log. Then a simple test is conducted as follows to prove this conjecture. Create an empty t. mdb file and Create Table table1 (id int primary key, cname varchar (10) Cr

If exists (select * From sysobjects where id = object_id (n' [DBO]. [sp_createdataloadscript] ') and objectproperty (ID, n' isprocedure') = 1) Drop procedure [DBO]. [sp_createdataloadscript] Go Create procedure sp_createdataloadscript@ Tblname varchar (128)As/*Exec sp_createdataloadscript 'mytable'*/ Create Table # A (ID int identity (1, 1), coltype int, colname varchar (128 )) Insert # A (coltype,

Recently, SQL stored procedures have been found to greatly reduce the amount of code in the program. In the future, we need to consider using more stored procedures. Two tips: 1. Use stored procedures to dynamically create data tables. /*Process function: dynamically create a data table in a stored procedureNote: connect the "single quotation marks" of the SQL statement"Created on: 2006-09-01Created by: skyjackerBlog: http: // blog.csdn.net/skyjacker*

Source: huide Control Network Using the documentbuilder. inserthtml method, aspose. Words can be inserted into a document in an HTML source. The input can be a complete HTML page or a part of the clip. In this way, we can use table elements such as C # 1234567891011121314151617 Document doc = new Document(); DocumentBuilder builder =newDocumentBuilder(doc);// Insert the

Create a table, insert an id column, and automatically generate an id. The id is automatically generated. USE [yuyongTest] GO -- Go: Execute now. The go statement segments the SQL Server script. After a segment is executed, the next segment can be executed, and the segments and segments are completely independent. Temporary variables that span go statements cannot be used universally. Declare @ name char (1

Create procedure [DBO]. [sp_createdataloadscript]@ Tblname varchar (128)As/*Exec sp_createdataloadscript 'mytable'*/ Create Table # A (ID int identity (1, 1), coltype int, colname varchar (128 )) Insert # A (coltype, colname)Select case when data_type like '% char %' Then 1 else 0 end,Column_nameFrom information_schema.columnsWhere table_name = @ tblnameOrder by ordinal_position If not exists (select

In fact, there is nothing in a double-chain table, but there is only one additional pre-chain. Double-chain table definition [Cpp]Struct DNode{Int data;Struct DNode * next;Struct DNode * pre;}; Single-chain table definition [Cpp] view plaincopyStruct DNode{Int data;Struct DNode * next;}; Others can be viewed in the previous blog, which is roughly the same [Cpp]#

In the project, you need to generate an Insert script for the data in the table, and find a stored procedure from the Internet. However, if an error is reported during execution, you can modify and debug it. Added support for SQL keywords or space-based field names, while ignoring self-growth field data. CREATE Procedure DBGenData @ TableName Varchar (100) -- table