In-depth understanding of some basic concepts in the database

1. How to understand transactional consistencyConsistency is one such thing, consistency has different definitions for different areas of application, because it is consistent with business rules, that is inconsistent, and this angle, consistency is

tsql--grouped by a field column, merging a column in one group into a row

In view of many colleagues in the group asked this question, I simply write a demo, hoping to help beginners!No truth, no commentary, no explanation, straight on code!--==================================================--sample code, for reference

Design and implementation of high-performance NoSQL ledisdb (1)

Splay Tree insert operation, only need to handle the insertion node of the child node is OK, the most important thing is not to destroy the basic rules of BST.Because height is not the primary factor for splay trees, the insertion is done using the

SQL string Segmentation

String: Declare @str varchar (+) = ' 0208588a_0208588,0098256a_0208588,0224208a_0224208, 'Split Result:Example sql:DECLARE @str varchar (+) = ' 0208588a_0208588,0098256a_0208588,0224208a_0224208, '--declare @str varchar (1000) = ' 0080203a_0080203,00

WinDbg Classic Deadlock debugging

Code//deadlock_debug.cpp: Defines the entry point of the console application. //#include"stdafx.h"#include"windows.h"#include//All the thread must get all of critial_section//Classic Deadlockcritical_section Gcritsecfirst; Critical_section

The role of the SQL foreign key

Seemingly useful, but not really used:SQL the role of the primary key and foreign key: Foreign key value rule: A null value or a reference primary key value. (1) when a non-null value is inserted, it cannot be inserted if the value is not in the

Loops in SQL

DECLARE @SOInfoList TABLE(Sonumber INT,Sodate datetime,Status char (1))INSERT into @SOInfoList(Sonumber,Sodate,Status)SELECT T.c.value (' (Sonumber/text ()) [1] ', ' int ') as Sonumber, T.c.value (' (Sodate/text ()) [1] ', ' nvarchar (+) ') as

Navicat linking the database on the LUnix platform

Xsell 4, Navicat softwareTo set in the general settings of the linked database:Link name, hostname (the IP address to ping after linking to the LUnix platform) port, user name, passwordThen select the SSH tab settings (check use SSH channel)Host,

Workaround for access to IIS metabase failure

This problem is usually encountered when doing the. NET development site, which is what I encountered at that time. The failed workaround for accessing the IIS metabase is as follows:Failed to access the IIS metabase. Description: An unhandled

Linux_shell Script _ Traverse folder all Files

Reference: lunar1983 's ColumnImplementation: grep from the given directory tree contains the line that made the string and gives the pathThe code looks like this:? 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

Platform_get_resource function in linux2.6.30.4 kernel

See the following two functions today:struct resource *platform_get_resource (struct Platform_device *dev,unsigned int type, unsigned int num){int i;for (i = 0; i num_resources; i++) {struct Resource *r = &dev->resource[i];if (type = = Resource_type

MyEclipse Developing memory overflow issues

MyEclipse Developing memory overflow issuesWindows---preferences--------------myeclipse Java VM arguments in optional:-xmx512m-xms256m-xx:maxnewsize=256m-xx:maxpermsize=256m-----------------------------------------------------------------------------

Handling Windowclosing in CDHtmlDialog

To intercept Window.close (), you have to intercept CDHtmlDialog's windowclosing. The following is the sample code:// Header Declare_eventsink_map () void windowclosing (Variant_bool ischildwindow, *cancel);// CPP Begin_eventsink_map

SAP ABAP SD Common BAPI

1. Create a BAPI for a standard sales order:BAPI_SALESORDER_CREATEFROMDAT22. Create a return sales order BAPI:bapi_customerreturn_create3. Change sales order BAPI:bapi_salesorder_change4. Create a delivery order based on the sales orders:

Windows7 with Window2008 64-bit IIS7 above DCOM config Excel, Word, etc.

Workaround:1. (Applies to. NET)1). Add the administrator privileges by adding impersonation to the Webconfig2). This will enable you to start the application process, manipulate Excel, create new Excel, export Excel, but still not open the

Mvc. Net:webapi adding support for JSONP

In some cases, we need to add support for JSONP in the WEBAPI project. For example, we created the mvc.net and Webapi two projects, the two projects using different ports, if the front end of the Mvc.net project want to directly access the WEBAPI

WinForm PictureBox reading an image file cannot be released

Today to do a photo program, the camera SDK everything is done, just to display the image and save the photo step card for half a day.The reason is that the preview image uses PictureBox and the image file is loaded in the following way:

Centos6.3 JDK and tomcat installation \ Configuration

Install and configure JDK and tomcat in Centos6.3: 1. JDK installation and configuration: A. Download JDK: : Http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html Here I downloaded: jdk-8u5-linux-x64.gz B. installation:

Use squid to set up your own Proxy Server

For more information, see Http://blog.chinaunix.net/uid-20778906-id-540115.htmlInstall and configure Squid Proxy Server in Ubuntu 1 Installation $ Sudo apt-get install squid After the installation is complete, it is found that squid3 is installed.

How to hide an object in an image

From: http://www.pixelstech.net/article/1347582974-Hide-a-file-in-a-picture From: http://blog.csdn.net/svitter What do you do if you want to hide important files on your computer that you don't want others to see? Looking for a professional tool?

Total Pages: 64722 1 .... 53460 53461 53462 53463 53464 .... 64722 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.