A Brief Introduction to the Statement SQL of ERP

Yesterday, I just finished a monthly sales growth analysis report independently. I found many problems and methods. I think it is necessary to record them.First, paste the code: /*dialect*/ select Fnumber,FName_l2,sum(NowFQty) NowFQty,sum(LastFQty) LastFQty,sum(NowFAmount) NowFAmount,sum(LastFAmount) LastFAmount,sum(NowFPrice) NowFPrice,sum(L ...

Posted on Wed, 27 Mar 2019 02:51:28 -0400 by moffo

T-SQL Statement (V) - Stored Procedures

T-SQL Statement (V) - Stored Procedures Introduction to Stored Procedures 1. Stored Procedures: A group of T-SQL programs written in advance to achieve a certain function. After specifying a program name, compiling it and storing it in SQL Server, the program can be called to complete the function later. 2. Advantages of stored procedures ...

Posted on Tue, 26 Mar 2019 23:18:28 -0400 by copernic67

Report Learning Summary (1) - Simple Use of ASP.NET Crystal Reports

I. Brief Introduction of Crystal Report Form Crystal Reports is a business intelligence( BI ) Software is mainly used to design and produce reports. Crystal Report is the most professional and powerful in the industry. Report system In addition to its powerful reporting function. The greatest advantage is the integration and interface with mos ...

Posted on Tue, 26 Mar 2019 22:09:31 -0400 by glennn3

mysql utf8mb4 character set, store emoji expression

Character set utf8mb4 utf8mb4 is compatible with utf8 and can represent more characters than utf8. Look at the unicode encoding region From 1 to 126, it belongs to the traditional utf8 area. Of course, utf8mb4 is compatible with this area. The extension area of utf8mb4 is below 126 lines. When you need to store those characters, you can only u ...

Posted on Mon, 25 Mar 2019 20:09:30 -0400 by boonika

toPredicate Method for Rewriting Specification for jpa Multi-Conditional Queries

Spring Data JPA supports JPA 2.0 Criteria queries, and the corresponding interface is Jpa Specification Executor. Criteria query: A type-safe and more object-oriented query. This interface is basically defined around the Specification interface, which defines only one method as follows: Predicate toPredicate(Root<T> root, CriteriaQue ...

Posted on Mon, 25 Mar 2019 18:18:28 -0400 by daeken

Thinking in SQL Series III: Supply and Demand Allocation

Originality: Niu Chao 2017-02-09 WeChat: ncfire     QQ10867910 Supply and demand allocation, in short, you have a variety of needs, I will personalize the supply to meet. Many problems can be transformed into such problems, which are widely used. For example, the table is full of tea cups and sea bowls, and the host serves coke, sprite, mil ...

Posted on Mon, 25 Mar 2019 13:45:28 -0400 by swebajen

A General History Method of Zipper Recording on hive

There are generally three recording methods for historical data in data warehouse. 1. Keep up-to-date records and calculate historical data with up-to-date data 2. Snapshots, keeping full data for each day 3. Zippers record history and record life cycles daily for changing data. Each of the above three has its own advantages, mainly re ...

Posted on Sun, 24 Mar 2019 20:36:27 -0400 by lovelyvik293

Realization of Personnel Management System (3)

As the carrier of communication with users, the main form has been preliminarily designed. When we press a function button, we can get a form with corresponding functions. We call these forms as sub-forms for the time being. 10 sub-forms are designed to implement the corresponding functions. The 10 sub-forms are placed in the PerForm folde ...

Posted on Sun, 24 Mar 2019 08:09:30 -0400 by soccerstar_23

Comparison of XunSearch Updating Index Scheme in Practice

Check the operating conditions of PHP-SDK (see if XunSearch is supported) $prefix/sdk/php/util/RequiredCheck.php $prefix# instead of your installation directory   There are many ways to use XunSearch and update index. Search syntaxQuery sentences are similar to popular search engines, which can connect search words and sentences through spac ...

Posted on Sun, 24 Mar 2019 02:30:28 -0400 by bravo14

Brother Cat takes you to the battle - Java Web Development - Java Chapter [9] - using SQL statements to add, delete and modify

The previous article has demonstrated how to connect to the database, because the work of connecting to the database is often done, so it is better to set up a class directly to deal with the database, which is more relaxing, not to mention much. The examples above are all in the notes. import java.sql.*;//Import database related class libr ...

Posted on Sun, 24 Mar 2019 01:09:29 -0400 by lazaruz