stay Timely Email Warning and Reminding of Blocking in Database (Part I) We build a new table to store blocked records, collect blocked stored procedures and configure sending mail to test ok, etc.
Step 4: Create a storage process for sending mail. There are two modes that you can choose according to your needs
Create a stored procedure for sen ...
Posted on Wed, 03 Jul 2019 15:53:38 -0700 by ksb24930
This article code repository: https://github.com/yu-linfeng/BlogRepositories/tree/master/repositories/sync
Start with an enrollment-level concurrent programming pen test
Title: Use 5 threads to execute concurrently, num digits count up to 10000, and print.
2 * Description:
3 * Using five threads to execute concurrently, num numb ...
Posted on Thu, 13 Jun 2019 10:00:16 -0700 by popsiclesph
Test environment: SQL Server 2012
The table structure is as follows
CREATE TABLE [dbo].[tt8](
[id] INT IDENTITY(1,1) NOT NULL,
[win_num] [int] NOT NULL DEFAULT ((0)),
[lost_num] [int] NOT NULL DEFAULT ((0)),
[draw_num] [int] NOT NULL DEFAULT ((0)),
[offline_num] [int] NOT NULL DEFAULT ...
Posted on Tue, 30 Apr 2019 15:30:37 -0700 by kaimason1
File and File Group Concept For documents and file groups, a brief summary is as follows. For details, please refer to the official documents.“ Database Files and Filegroups ” More relevant information: Data file concept: Each SQL Server database contains at least two system files: a data file and a log file. Data files contai ...
Posted on Wed, 24 Apr 2019 20:27:36 -0700 by driverdave
SQL statements can be divided into the following three categories.
DDL (Data Definition Languages) statements: Data Definition Languages, which define different definitions of database objects such as data segments, databases, tables, columns, indexes, etc. The commonly used keywords include create, drop, alter and so on.
The operating langua ...
Posted on Tue, 02 Apr 2019 11:18:29 -0700 by Azzyh
In SQL Server, how to use SQL to achieve the complete combination of a batch of strings? This is a problem that colleagues encounter in their actual needs. His specific needs are as follows:
The input parameter formats are'1, 2, 3, 224, 15, 6''A,BC,GHT,TTY,B,E'
The output is all Non-permutated combinations of split strings
Posted on Sun, 31 Mar 2019 23:18:30 -0700 by torrentmasta
Classification of SQL
DDL - Data Definition Language (CREATE, ALTER, DROP, DECLARE)
DML - Data Manipulation Language (SELECT, DELETE, UPDATE, INSERT)
DCL - Data Control Language (GRANT, REVOKE, COMMIT, ROLLBACK)
II. Basic Sentences
2.1. Description: Create a database
create database db-name
2.2. Note: Delete the database
drop database db-n ...
Posted on Mon, 25 Mar 2019 15:15:30 -0700 by Schneider707
SqlServer Creates Data Table Description and Column Description Information
Q: Why create descriptive information?
A: When the mouse hovers over the corresponding tables and columns, descriptive information will appear, which can improve the efficiency of the work. With the help of tools, we can generate Model according to the data tab ...
Posted on Wed, 20 Mar 2019 11:06:26 -0700 by hyster
This month, I met several people who asked me about the performance of INNER JOIN and IN in SQL SERVER. This problem. In fact, this summary is the superiority and inferiority of INNER JOIN and sub-query in SQL Server (IN is one of the ways to implement sub-query, this article only compares the performance of INNER JOIN and sub-query IN. If we c ...
Posted on Sat, 22 Dec 2018 18:27:06 -0800 by bigfunkychief