id="selectUser" //Method corresponding to PersonMapper.java interface
parameterType="int" //Input parameter format
resultType="hashmap" //Return data type. When multiple parameters are returned, resultMap is recommended.
resultMap="userResultMap" //The data type returned is equivalent to encapsulating resultT ...
Posted by eheia on Tue, 19 Mar 2019 03:15:26 -0700
After removing the transaction log file in SQL Server, when checking with sys.master_files, it is found that the corresponding transaction log file record information still exists in sys.master_files, except that the state_desc is OFFLINE. It will take some time for this record to disappear from the system view.
DECLARE @db_name NVARCHAR(32) ...
Posted by uatec on Tue, 19 Mar 2019 01:54:27 -0700
From the following test results, it is easy to see that the left-related query statement will be transformed into an internal correlation as long as there is a WHERE filter condition.
1. Creating tables
Demonstrate the use of random creation of two tables
CREATE TABLE T_CLASS(
class_id NUMBER not null,
class_name VA ...
Posted by cyronuts on Mon, 18 Mar 2019 20:36:26 -0700
Introduction to Data Lake Analytics (DLA)
For more reading about the concept of Data Lake, you can refer to:https://en.wikipedia.org/wiki/Data_lake
And AWS and Azure's interpretation of Data Lake:https://amazonaws-china.com/big-data/datalakes-and-analytics/what-is-a-data-lake/https://azure.microsoft.com/en-us/solutions/data-lake/
Finally, Al ...
Posted by crazydip on Mon, 11 Mar 2019 01:51:25 -0700
Query table A and table B has records at the same time, table A exists and table B does not have records, table B exists and table A does not have records.
As shown above, where:
Area A is a collection of old tables and new tables.
The C region is a collection of new tables and old tables.
Area B is a common set of old an ...
Posted by php_gromnie on Thu, 14 Feb 2019 17:06:18 -0800
Environment: Virtual Machine Windows Server 2016 (powershell 5.1) + SQL Server 2016 CTP3
Basically using Powershell script configuration. Here, when creating certificates and endpoints, we use SQL commands. In fact, PS has related commands to complete. This script is just a personal whim to try to script the way to configure AG, are the basic ...
Posted by ecko on Thu, 14 Feb 2019 01:36:18 -0800
Using reflection to realize sql query and get persistent objects
The Title can't think of simple words. If you want to find out the relevant information, you should first see if the method structure is in line with your appetite.
public static <E> List<E> getObjectBySql(String sql,E e)
List<E> list = new ArrayList ...
Posted by ckuipers on Wed, 13 Feb 2019 20:54:18 -0800
First, create a new table and insert values:
DROP TABLE IF EXISTS table_score_one;
CREATE TABLE table_score_one (
id INT (10) NOT NULL PRIMARY KEY auto_increment,
student_no VARCHAR (10) NOT NULL,
student_name VARCHAR (10) NOT NULL,
class_no VARCHAR (10) NOT NULL,
class_name VARCHAR (10) NOT NULL,
score IN ...
Posted by webmaster1 on Wed, 13 Feb 2019 04:48:19 -0800
Take the last part.
Staying up late may hurt, but it's surprisingly efficient. Originally, it can be very happy to do one thing without distraction.
This Excel Daily will be a powerful supplement to my iKB system.
iKB system is similar to business transaction system for me to carry out daily knowledge base management; Excel Daily also allows ...
Posted by Zanne on Wed, 13 Feb 2019 02:42:18 -0800
(1) Installing freeTDS
FreeTDS provides an open source client of TDS protocol for Linux system. Because MS SQL and Sybase use the TDS protocol, they can connect MS SQL with FreeTDS in Linux.Official website: http://www.freetds.orgDownload: wget http://ibiblio.org/pub/Linux/ALPHA/freetds/stable/freetds-stable.tgzInstallation:[root@vm01 ~]# ta ...
Posted by ypkumar on Wed, 13 Feb 2019 02:18:20 -0800