Category：MsSql
-
Time：2020-4-2
MySQL is an open-source relational database management system of Oracle company, which is widely used in small and medium-sized websites. It is a cross platform database management system. Now, how to install and configure MySQL on Ubuntu 14.04 is introduced Method / step 1. Update source list Open the “terminal window” and enter “sudo apt […]
-
Time：2020-4-2
Classic examples of database and information system @Langyuan qihan Updated on: January 3, 2020 This is the final version. The classic examples are from the course “database and information system”. They are only for academic exchange and final review. If there is any mistake, please point out the source when reprinting! 1、 Basic concept verification […]
-
Time：2020-4-1
This paper shares two examples about row to column horizontal display of SQL query statements for your reference. The details are as follows Example 1: There is no case in access in row to column horizontal display of SQL query statement, so IIF should be used instead Select IIF (sex = ‘1’, ‘male’, ‘female’) from […]
-
Time：2020-4-1
Before that, I wrote the description of MS SQL adding fields https://www.cnblogs.com/insus/p/12106589.html Now, we get the description values of these fields. Let’s start with a select statement: SELECT * FROM sys.extended_properties GO Source Code In the above SQL statement, although we get the described value, we don’t know which table and which field […]
-
Time：2020-3-31
The example of this article shares a simple friend circle program, including the list implementation of friend circle, video recording, preview and upload, pictures can be taken for your reference, the specific content is as follows Friendslintactivity codeas follows public class FriendsListActivity extends BaseActivity implements OnRefreshListener<ListView>, PostListener { private InteractionAdapter mAdapter; private PullToRefreshListView mRefreshListView; private […]
-
Time：2020-3-31
1. When we create the primary key of the data table of SQL server, sometimes a string of random strings will be added, as shown in the figure: 2. If you have obsessive-compulsive disorder, you can use the following SQL script to modify the name of the primary key to the PK UU table […]
-
Time：2020-3-30
Just opened SQL Server 2008, want to create a new database, but found a problem, this problem has not been encountered before, so the following sorting out several methods to solve the SQL Server Service remote call failure, for your reference, the specific content is as follows Let’s look at the problems: The reason for […]
-
Time：2020-3-30
Summary: Floating point data types include real type, float type, decimal type and numeric type. Floating point data types are used to store decimal numbers. In SQL server, the data of floating-point value is stored by round up. The so-called round up means that the decimal part to be rounded is regardless of its size, […]
-
Time：2020-3-29
This paper shares two methods of SQL Server database recovery and backup for your reference. The specific contents are as follows The first method:Usually, we use the method of restoring backup to select the target database and the source device.The screenshot is as follows: The second method:This way is not convenient sometimes, and the script […]
-
Time：2020-3-29
1. In the use of database, deadlock may occur, causing the program to be unable to use normally Create procedure [dbo].[sp_who_lock] (@Bkillpid bit = 0 — 0: query 1: end corresponding deadlock ID (may cause data exception)) as begin declare @spid int declare @blk int declare @count int declare @index int declare @lock tinyint set […]
-
Time：2020-3-28
How to save tree data? The parent node method is commonly used in SQL. Create the table as follows CREATE TABLE category ( id LONG, parentId LONG, name String(20) ) INSERT INTO category VALUES ( 1, NULL, ‘Root’ ) INSERT INTO category VALUES ( 2, 1, ‘Branch1’ ) INSERT INTO category VALUES ( 3, 1, […]
-
Time：2020-3-28
Absrtact: in the SQL Server database, the method of converting date data to specified format is described below; Experimental environment: sqlserver 2008 R2 Implementation ideas: Implementation method 1: use the year function and month function to obtain the corresponding values, and then use string splicing method to output the corresponding data Implementation method 2: convert […]
