insert into temp table from stored procedure

If the content is not good, please forgive me To meet project requirements, we need to create temporary tables and temporary functions in a stored procedure to merge the return tables of N tables in a stored procedure. This creates a lot of trouble, now we have finally finished it. Let's take a look at the final code.

Example: insert multiple categories into the commodity classification table. Create procedure tproduct_add@ Proid bigint output, -- automatic number@ ISBN nvarchar (50 ),@ Pcode nvarchar (100 ),@ Pname nvarchar (200 ),@ Unit nvarchar (50 ),@ Price decimal (18,2 ),@ Purchaseprice decimal (18, 2 ),@ Discount decimal (4, 2 ),@ Membeprice decimal (18,2 ),@ Membeprice

-- ===================================================== =-- Author: -- Description: -- Return: 0 is returned for success, and 1 is returned for duplicate names.-- ===================================================== =Create procedure [DBO]. [up_class_insertex]@ Newid uniqueidentifier, -- New Record ID@ Classtype nvarchar (50), -- type (for example, product, news, and Region)@ Parentid uniqueidentifier, -- parent class ID@ Classname nvarchar (50), --

+ 1) AS newid, stotal, username FROM (select sum (total) stotal, username FROM exercise WHERE (username IN (SELECT username FROM ofRoster WHERE jid = CONCAT (usname, jidb) OR username = usname) AND createtime BETWEEN startday AND startday) group by username order by stotal DESC) a) a1 WHERE username = usname; insert into tmp_sportdata VALUES (totala, ranking, totalamonth, rankmonth, totaladay, rankday, usname); end loop; CLOSE cur_usname; SELECT * FR

,a.danweiname,'Geneva', Note - fromPx_inportscore a + JoinPk_user b onA.identitynum=B.identitynum A whereB.rowguid not inch(SelectUserguid fromPx_baom) at - - ) - - Insert intoPx_baomdetail (rowguid,itemguid,itemname,isdel,classguid,parentguid,isconfirm) -(--INSERT into the Registration sub-table condition:

Create PROCEDURE [dbo]. [outputdata]@ Tablename sysnameASDeclare @ column varchar (1000)Declare @ columndata varchar (1000)Declare @ SQL varchar (4000)Declare @ xtype tinyintDeclare @ name sysnameDeclare @ objectId intDeclare @ objectname sysnameDeclare @ ident int Set nocount onSet @ objectId = object_id (@ tablename) If @ objectId is null -- determine whether the object existenceBeginPrint 'the object not exists'ReturnEndSet @ objectname = rtrim (ob

), @ o_return int output -- declare out parameter AsBeginDeclare @ ID int;-- Set nocount on added to prevent extra result sets from-- Interfering with select statements.Set nocount on;Insert into customarea (areaname, userid, corpid, arealatlon, areaweblatlon, remark,Centerweblatlon, centerlatlon, imageurl, areawidth, areahigh, acreage)Values (@ areaname, @ userid, @ corpid, '', @ areaweblatlon, @ remark,@ Centerweblatlon, @ centerlatlon, @ imageurl

The previous article briefly describes the Oracle parameter is a database stored procedure of type Object and Java uses JDBC to invoke the method of the class's stored procedure. But what I need is a scenario under C + + that uses Poco libraries to find no way to invoke that type of

names.Select Count (*) AS Qty FROM MSysObjects Where (MSysObjects. Name) Like 'table name '); Copy codeThe Code is as follows: whether the library exists If exists (select * from master .. sysdatabases where name = N 'database name ') Print 'exists' Else Print 'not exists' --------------- -- Determine whether the table name to be created exists If exists (select * from dbo. sysobjects where id = object_id

Recently, a small project is not very complex, it is necessary to backup some data of one database to another library. Not local, it could be another database on the network. Think about it, using stored procedures and triggers.is not very complex, first I need to operate the remote database, and then wrote a stored procedure:CREATE PROCEDURE sendinfotoremotedb @

primary key is set sequence the next value by default CREATE TABLEC # #EM. Gp_target_type (ID Number( +)DEFAULT"C # #EM". Iseq$$_124895". Nextval not NULL,--default defaults to the next value of SEQNAME NVARCHAR2 ( -) not NULL, REMARK NVARCHAR2 ( $), Create_time DATE not NULL, Create_uid Number( +), Delete_uid Number( +), Delete_time DATE, Is_delete Number(1) not NULL, Update_time DATE, Update_uid Number( +) ) 2) If the value of the primary key ID is obtained by the user's own sequence value,

Determines whether a table (temporary table) exists and whether a stored procedure exists.1. Determine whether a formal table or stored procedure has a select * from dbo. sysobjects whe

Mysql stored procedure: copy A column of Table A to Table B to go to bitsCN.com Mysql stored procedure: copy A column of Table A to Table B

--A stored procedure that generates INSERT statements based on data in a tableCreate Proc Proc_insert (@tablename varchar (256))As--table nameBeginSET NOCOUNT ONDeclare @sqlstr varchar (4000),@sqlstr1 varchar (4000),@sqlstr2 varchar (4000)Select @sqlstr = ' select ' ' Insert

Label: -- ============================================= --Author:jf_ou --Create DATE:2016/03/22 --Description: Plug-in related configuration to configuration table--eg:--EXEC addsysparametersforprojects ' father ', ' son ', ' 123, 1234, 12345, 123456 ', ', ' -- ============================================= Create PROCEDUREaddsysparametersforprojects@varf nvarchar( -),--Parent Parameter @vars nvarchar( -),--Sub-parameters @strs nvarchar(Max)

MySQL does not support arrays. However, sometimes it is necessary to combine several tables of data, in the stored procedure, after the more complex operation obtained the results of direct output to the caller, such as the number of tables matching the conditions of some of the combined calculation of some fields, MySQL temporary table can solve the problem.

{Rs.close ();Ps.close ();Conn.close ();} catch (SQLException e){E.printstacktrace ();}}}public void Callproc ()//Call stored procedure with return value{Strbuf.delete (0, Strbuf.length ());Sqlstr = "";Try{if (conn = = NULL | | conn.isclosed ()){conn = getconnection ();}} catch (SQLException e){E.printstacktrace ();}Try{CallableStatement Callproc = Conn.preparecall ("{Call Sp_tablea (?,?)}");Callproc.setint

A netizen wants to create a table for each new user. I wrote down the following process for him and how to call the stored For referenceCreate procedure autocreatetable@ Tablename char (10)As Exec ('Create Table '+ @ tablename +'(Id int identity (1, 1) primary key,Name char (16))')Go How to call a

This is a stored procedure used to copy the value of the avalue column in table A to the bvalue column in table B (assume that both table A and table B have the same column named ID) Create

Mysql stored procedure: copying A column of Table A to table B is A stored procedure, copy the value of the avalue column in table A to the bvalue column in