• SQL Server database BCP export backup file application example


    /** *Authorization */ EXEC sp_configure ‘show advanced options’,1; go reconfigure; go exec sp_configure ‘xp_cmdshell’,1; go reconfigure; go /**Imports a text file for the specified table*/ EXEC master..xp_cmdshell ‘bcp dbname..tablename in d:\DT.txt -c -Sservername -Usa -Ppassword’ exec master..xp_cmdshell ‘bcp “select * from dbname..tablename” queryout “D:\20140528.xls”-c -Sservername -Uuser -Ppassword’ xp_ Cmdshell parameter description The following is a […]

  • Asp.net method of exporting excel general class using npoi


    To solve the problem of Excel garbled code in saving Chinese file names, mainly judge Firefox or IE browser, and then make corresponding judgment. The core code is as follows: System.Web.HttpContext.Current.Response.ContentType = “application/vnd.ms-excel”; //Set the name of the downloaded excel file\ if (System.Web.HttpContext.Current.Request.ServerVariables[“http_user_agent”].ToString().IndexOf(“Firefox”) != -1) { //Firefox browser System.Web.HttpContext.Current.Response.AddHeader(“Content-Disposition”, string.Format(“attachment;filename={0}”, “=?UTF-8?B?” + Convert.ToBase64String(System.Text.Encoding.UTF8.GetBytes(fileName)) + “?=”)); […]

  • Process analysis of exporting excel from c#winfrom


    This article mainly introduces the c#winfrom export excel process analysis, the article through the example code is very detailed, for everyone’s study or work has a certain reference learning value, need friends can refer to It is exported in the form of DataGridView and npoi.dll is used 1. Because the DataGridView is used, the class […]

  • Java based on POI export excel PivotTable code example


    This article mainly introduces the Java based POI export excel PivotTable code example, the article through the example code is very detailed, for everyone’s study or work has a certain reference learning value, need friends can refer to Once upon a time, I was a front-end program ape. With the dream of getting through Ren […]

  • PHP uses fputcsv to realize the export operation of big data


    In this paper, an example is given to show how to export big data by using fputcsv in PHP. The details are as follows: In order to experiment with big data export, we create a large table by ourselves. The table structure is as follows: CREATE TABLE `tb_users` ( `id` int(11) unsigned NOT NULL AUTO_ […]

  • How to export project from eclipse


    Eclipse is an open source, Java based extensible development platform. In itself, it is just a framework and a set of services for building a development environment through plug-in components. Fortunately, eclipse comes with a standard set of plug-ins, including the java development kit (JDK). How does eclipse export a project? Some small white programmers […]

  • Export data to XML and share with JSON method in SQL Server


    Sometimes it is necessary to export the data in SQL server to other departments at one time for correlation or analysis. Of course, this requirement is very simple for SSIS, but it is a big deal to establish a SSIS package just by exporting the data at one time. There are many bugs in the […]

  • Oracle uses toad to import and export Excel data


    In the development process of Oracle application program, accessing database objects and writing SQL program is a tedious and time-consuming work, and daily database management also needs a lot of SQL scripts to complete. Quest software provides an efficient Oracle Application Development Tool toad. In the new version of toad, DBA module is added, which […]

  • Thinking about PHP memory overflow


    background Recently, when doing large-scale data export and data import, we often encounter the problem of PHP memory overflow. After solving the problem, we summarize some experience and make a record of it. Optimization point Optimize SQL statement, avoid slow query, reasonably establish index, query specified fields, SQL optimization will not be expanded here. When […]

  • The method of JSP exporting excel file


    The example of this paper describes the method of exporting excel file by JSP. To share with you for your reference, as follows: <%@page import=”jxl.Workbook,com.ecc.emp.core.*,com.ecc.emp.data.*,com.ecc.emp.jdbc.ConnectionManager,jxl.format.VerticalAlignment,java.sql.*,jxl.write.*,jxl.format.UnderlineStyle,javax.sql.DataSource”%> <%@page language=”java” contentType=”text/html; charset=UTF-8″%> <%@taglib uri=”/WEB-INF/CTP.tld” prefix=”ctp”%> <jsp:directive.page import=”java.util.List”/> <jsp:directive.page import=”java.util.ArrayList”/> <%@ include file=”http://www.xxxx.com/head.jsp” %> <% Context context = (context) request.getattribute (“context”); string flag = “transaction date, transaction time, summary, […]

  • Mongodb database operation backup restore export import


    1、 Mongodump backup database 1. Common command cell Mongodump – H IP — Port Port – U user name – P password – D database – O file existence path If there is no user who can remove – U and – P.If you export the native database, you can remove – H.If it is […]

  • JSP export excel and support the method of sub sheet export


    The example of this paper describes the method of exporting excel from JSP and supporting the export of sub sheet. To share with you for your reference, as follows: public DownloadFile exportToExcel() throws Exception{ String config_value = systemConfigService.getConfigValueByKey(“Export.Xls”); Logger.info (“the obtained export type is EXECL table” + “, and the number of rows exported per […]