insert into temp table from stored procedure

Recently got a small project, it is not very complicated, need to backup some data of one database to another library, not local, possibly other database on the network, think about, use stored procedures and triggers. is not very complicated, first I need to operate the remote database, so I wrote a stored procedure:CREATE PROCEDURE sendinfotoremotedb @CardNo va

The previous article briefly describes the Oracle parameters database stored procedure of type object, and how Java uses JDBC to invoke stored procedures of that class.But what I need is a solution under C + +. Using POCO libraries did not find any way to invoke the type of stored procedures, but the functionality stil

Processing purpose: execute UPDATE when the target record exists in the data table. when the target record does not exist in the data table, execute INSERT. the stored procedure design for reducing the number of queries to the database is as follows: CREATEPROCEDURE 'Pro _ s

#temp Ii. insert1. To use insert into, you must manually create a temporary table. 1.1 Save the result set returned from the SELECT statement. create table test_getdate(c1 datetime)insert into test_getdate select GETDATE()select * from test_getdate 1.2 Save the result se

Create a test table: MySQL> Create TableBigdata (IDint, nameChar(2) ; Create stored procedure: MySQL>Delimiter//MySQL> Create procedureRand_data (inchNumint) - begin - Declare Str Char( +)default 'abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789';--a total of 62 characters. - Declarestr2Char(2); - DeclareIint default 0; - whileINum do - Setstr2=Co

Recently, a friend asked why a sqldatasource call with a parameter stored procedure failed,CodeAs follows: Code Code highlighting produced by Actipro CodeHighlighter (freeware)http://www.CodeHighlighter.com/--> String User_name = (Textbox) This . Detailsview1.rows [ 1 ]. Cells [ 1 ]. Controls [ 0 ]). Text. tostring (). Trim (); String Pass_word = (Textbox) This . Detailsview1.rows

dataItem_cursorDEALLOCATE dataItem_cursor/*Perform logical processing, insert, or update operations here...Www.jb51.net*/ENDCLOSE data_cursorDEALLOCATE data_cursor 2. While Mode The Code is as follows:DECLARE @ Data NVARCHAR (max)SET @ Data = 'tanw, keenboy '-- Id, NameDECLARE @ Temp TABLE(Id int identity (1, 1 ),Name NVARCHAR (50))DECLARE @ Id INTDECLARE @ Name

1. cursor Mode Copy codeThe Code is as follows:DECLARE @ Data NVARCHAR (max)SET @ Data = '1, tanw, 2, keenboy '-- Id, NameDECLARE @ dataItem NVARCHAR (100)DECLARE data_cursor cursor for (SELECT * FROM split (@ Data ,';'))OPEN data_cursorFetch next from data_cursor INTO @ dataItemWHILE @ FETCH_STATUS = 0BEGINDECLARE @ Id INTDECLARE @ Name NVARCHAR (50)DECLARE dataItem_cursor cursor for (SELECT * FROM split (@ dataItem ,','))OPEN dataItem_cursorFetch next from dataItem_cursor INTO @ IdFetch next f

You must have had such troubles. The same table and different databases cannot be added to select insert.Therefore, you must enter a stored procedure to indicate that the insert statement will generate data for you.Of course, the number of data tables is too large. You 'd better use another method. Copy codeThe Code is

You must have had such trouble, the same table, different database, join you can't perform select InsertThen you definitely need a stored procedure that needs to be passed in and will give you the INSERT statement that generates the data.Of course the number of data sheets is too large, you'd better use another way

Tags: php process mys review href encounter roc cat Te ProDo the project process encountered the need to insert an ordered test data, do not want to write PHP loop, online Find methods, review the stored procedure again haha.SQL statement Reference from Https://stackoverflow.com/questions/26981901/mysql-insert-with-whi

1. cursor Mode CopyCode The Code is as follows: declare @ data nvarchar (max) Set @ DATA = '1, tanw, 2, keenboy '-- id, name Declare @ dataitem nvarchar (100) Declare data_cursor cursor for (select * From Split (@ data ,';')) Open data_cursor Fetch next from data_cursor into @ dataitem While @ fetch_status = 0 Begin Declare @ ID int Declare @ name nvarchar (50) Declare dataitem_cursor cursor for (select * From Split (@ dataitem ,','))Open dataitem_cursorFetch next from dataitem_cursor into

from syscolumns C where order by C. colidOpen syscolumns_cursorSet @ column =''Set @ columndata =''Fetch next from syscolumns_cursor into @ name, @ xtypeWhile @ fetch_status BeginIf @ fetch_status Begin-- If @ xtype not in (189,34, 35,99, 98) -- timestamp does not need to be processed. Image, text, ntext, SQL _variant will not be processed for the moment.BeginSet @ column = @ column + case when Len (@ column) = 0 then 'else', 'end + @ nameSet @ columndata = @ columndata + case when Len (@ colum

' + '''n' ''' +' + 'Cast (replace ('+ name + ', ''', ''') as char ('+ Cast (length as varchar) + ')) + ''' + 'end'Else '''null '''End as cols,NameFrom syscolumnsWHERE id = Object_id (@ tablename) TSET @ SQL = 'select' insert into ['+ @ tablename +'] '+ LEFT (@ SQL, Len (@ SQL)-1) + ') '+ LEFT (@ sqlValues, Len (@ sqlValues)-4) +') 'from' + @ tablenamePRINT @ SQLEXEC (@ SQL)END -- Execute the stored

A.TargetPeriod like '%123%' and E.OrgCode like '%123%'order by A.TargetPeriod desc,C.SalesName,D.CatalogName The preceding SQL statement contains some special cases, such as the Convert function, no primary key, multi-table join, table alias, and field alias. These cases may be tricky to handle, of course, the "'' as CheckBox "is a special case in my system and is used for some processing. I am here to pro