stored procedure to insert data into table from another table

　　Step 1th , open the word2007 document, click the Table button in the table group in the Insert Ribbon, and select Excel Spreadsheet in the Open menu, as shown in figure. Figure Cli

Label:Creating test tables and test dataCREATE TABLE Test (ID number,name varchar (10));INSERT into test values (1, ' Liufang ');INSERT into test values (2, ' Xiaozhang ');INSERT into test values (3, ' Dawei ');INSERT into test values (4, ' Laotan ');

End Sl. SaveToFile (Extractfilepath (application.exename) + ' export.sql '); Sl. Free; Tables. Free; End Procedure Tform1.importdata (const fileName, tablenames:string); var cmd, tables:tstringlist; Err, sql:string; I:integer; Begin if (not FileExists (fileName)) or (Tablenames = ') then exit; Tables: = Tstringlist.create; Tables. Delimiter: = ', '; Tables. Delimitedtext: = Tablenames; For I: = 0 to tables. Count-1 do begin sql: = ' truncate

@ columndata =''Fetch next from syscolumns_cursor into @ name, @ xtypeWhile @ fetch_status BeginIf @ fetch_status BeginIf @ 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 (@ columndata) = 0 then ''else', '','', 'end+ Cas

Tags: style color data div on SP SQL CBulk Insert Table (table data Sheet) * * * *1.INSERT into SELECT statementThe statement form is:Insert into Table2 (field1,field2,...) Select Value1,value2,... from Table1Requires that the tar

Sequential table of various operations (including header delete, tail delete, insert, reverse order, destroy, empty etc.)//header file #ifndef _seqlist_h#define _seqlist_h#include"Data structure" in C language implementation of sequential table of various operations (includi

then' 'null' 'else' + 'convert (varchar (23), '+. name + ', 2)' + 'end'When. xtype = 58 then 'case when' +. name + 'is null then' 'null' 'else' + ''' + 'convert (varchar (23),' +. name + ', 121)' + ''' + 'end'When. xtype = 52 then 'case when' +. name + 'is null then' 'null' 'else' + 'convert (varchar (12), '+. name + ')' + 'end'When. xtype = 122 then 'case when' +. name + 'is null then' 'null' 'else' + 'convert (varchar (22), '+. name + ')' + 'end'When. xtype = 48 then 'case when' +. name + 'is

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, co

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

'Must click the menu "Project/reference/Microsoft Word 9.0 Object Library"Dim WD as new word. Application'Insert a table with three columns and six rows and insert data to each table row.WD. Documents. Add documenttype: = wdnewblankdocumentSet odoc = WD. activedocumentSet otable = odoc. Tables. Add (range: = odoc. Rang

is added, updated, or deleted to table [A], it triggers the corresponding operation for table [B] and modifies the stored procedure of table [B. Modify the stored procedure of table [B] dynamically: The Code is as follows: Creat

There is a table that you need to operate on in the background and want to dynamically add and delete fields to it. This feature may be fine, but it also needs to be modified together with the original two stored procedures for insertion and update. Therefore, Insus. NET implements it. Therefore, this article will show you how to dynamically add and delete fields to a t