Category：MsSql
-
Time：2021-8-2
catalogue 1、 Creation and deletion of database and table 1. Create database 2. Modify database 3. Delete database 4. Create data table 5. Delete data table 2、 Common operations of data table 1. Add a new field to the table structure 2. Delete fields in the table structure 3. Data sheet renaming 3、 Data addition, […]
-
Time：2021-8-1
Note: if the path cannot be changed, search the path to delete the registry record, and then restart the computer Press win keyboard + R to enter regedit into the registry, click the computer and press “Edit” — “to find the next one It will take some time When the results come out, delete the […]
-
Time：2021-7-31
Due to the special design of sqlserver, a large amount of data is generally divided into horizontal tables, while the vertical tables only put the large data of text and pictures into a separate table. In this way, the data design will be more reasonable and may be better than mysql. MSSQL is originally a […]
-
Time：2021-7-30
catalogue 1. The concept of cross join 2. Syntax format of cross join 3. Usage scenario of cross query 3.1 cross connection can query all data 3.2 cross join optimization query performance 4. Summary Today, I will introduce the usage of cross connection in SQL server. I hope it can be helpful to you! 1. […]
-
Time：2021-7-29
Reading time |1.14 minutes word count |1825.6 characters primary coverage |1. Introduction & background “MSSQL · take a record according to the maximum value of multiple fields and grouping according to a field” Author | SCscHero Writing time | 2021/7/12 PM12:0 Article type |Series Degree of completion |Completed motto Every great cause has a trivial […]
-
Time：2021-7-29
Subquery can complete complex situations in SQL query. This chapter mainly introduces the simple usage of some subqueries. 1、 Simple subquery 1. Simple subquery A subquery is another select statement within a select statement. In general, subqueries can be used wherever expressions can appear in a statement. In addition, subqueries can extract data from any […]
-
Time：2021-7-28
Reading time |0.27 minutes word count |444 characters primary coverage |1. Introduction & background “MSSQL · query and sort the records of all tables in a database” Author | SCscHero Writing time | 2021/7/13 PM10:0 Article type |Series Degree of completion |Completed motto Every great cause has a trivial beginning. 1、 Introduction & background Completion: […]
-
Time：2021-7-28
catalogue Batch insert 1. Execute SQL statements in batch 2. Efficient batch insertion Batch insert 1. Execute SQL statements in batch When you need to insert or update records in batches, you can use the batch update mechanism of Java, which allows multiple statements to be submitted to the database for batch processing at one […]
-
Time：2021-7-27
Reading time |0.13 minutes word count |214.4 characters primary coverage |1. Introduction & background MSSQL · according to constraints_ Table name query constraint_ Table name Author | SCscHero Writing time | 2021/7/13 PM11:10 Article type |Series Degree of completion |Completed motto Every great cause has a trivial beginning. 1、 Introduction & background Completion: 100% a) […]
-
Time：2021-7-27
Problem scenario Changes in three scores (logistics, services and commodities) of major platform stores;Records of daily changes in commodity prices;Real time fluctuation of stocks; Reproduction scene Table: primary key ID, commodity number, time when recording, price when recording, and creation time.Question: get the change of each commodity (rise and fall range, rise and fall rate). […]
-
Time：2021-7-26
Reading time |0.23 minutes word count |370.4 characters primary coverage |1. Introduction & background “MSSQL · prevent saving configuration changes requiring table re creation” Author | SCscHero Writing time | 2021/7/15 PM9:0 Article type |Series Degree of completion |Completed motto Every great cause has a trivial beginning. 1、 Introduction & background Completion: 100% a) Dealing […]
-
Time：2021-7-26
catalogue Software environment preparation Installing. Net Framework 3.5 SP1 Installation sequence of IIS, SQL server and vs Installing SQL server2014 Three new features of SQL Server 2014: integrated memory OLTP, Bi and hybrid cloud construction. Please record our installation process and configuration. Software environment preparation The operating systems supported by SQL Server 2014 include: Windows […]
