SQL Server

The use of SQL Server stored procedures can greatly improve the speed of the program, simplifying the difficulty of programming maintenance, has been widely used.Create a stored procedureAs with a data table, you need to create a stored procedure

Inter-function　　1. Get the current date getdateThe GETDATE () function returns the date and time of the computer on which the current SQL Server servers are located, in the format of the datetime data type. Its syntax format is GETDATE (). The

Due to the previous period of stomach pain, the blog Park blog has been stopped more than one months or so. In recent days, stomach trouble finally slightly improved, decided to re-write blog post.A few days ago, a friend just asked me about the SQL

SQL Server supported data types for getting started with SQL ServerCommon data types1. Integral type data1) bit, can only store 0, 1, and null values null.2) tinyint, a positive number without a sign bit, takes 1 bytes, 8 bits, and supports a data

CREATE TABLE Test(Department varchar (10),Customer varchar (10),Cost name varchar (10),Amount int)INSERT into test values (' A ', ' a ', ' phone fee ', 10)INSERT into test values (' A ', ' a ', ' run at public expense ', 11)INSERT into test values ('

The above functions are all new time functions in SQL Server 2012.EOMONTHReturns the month end date of the incoming time, the return data type is dateSELECT EOMONTH (GETDATE())Result is . - on - toDatefrompartsAs in C # or Java declares a DateTime

Preparatory work:In order to detect deadlocks, we need to simulate the deadlock first. This example creates two transactions using two different sessions.Steps:1. Open SQL Server Profiler2. Select "New trace" to connect to the instance.3. Then

SQL Server aggregate function in the actual work to meet the needs of a wide range of requirements, and for the optimization of the aggregation function has become a focus, a program optimization of the good or bad directly determines the

Lee and server connection errors.at the time of connection to SQL Server 2005. In the default setting, SQL Server does not agree with remote connections that may cause this failure. (provider: Named Pipes provided, ERROR:40-unable to open SQL Server

One, local time and UTC timelocal timeEach region of the world has its own local time, the entire earth is divided into 24 time zones, each time zone has its own local time.UTC timeIn international radio communications, a standard time is commonly

Starting with SQL SERVER 2008, we are no longer able to use the previousDUMP TRAN database name with NO_LOGThis way to shrink the database, however, you can use another alternative method, the SQL statement is as follows:ALTER database name set

I used to want to know what the difference was, but it was forgotten because we seldom used a unique key constraint. It was not until a few days ago that my colleague gave me a script to constrain the uniqueness of a field with a unique key

Today in SSMs (Microsoft SQL Server Management Studio), click on the left side of the explorer to view the database corresponding to the table, you will encounter "Lock Request time out period exceeded." (Microsoft SQL Server, error 1222) ", the

In today's article I would like to discuss a special T-SQL language structure in SQL Server-the pivot operator introduced from SQL Server 2005. I often cite this and the language structure is the most dangerous one in SQL Server--and soon you'll

Row-Level Security (worth noting) of SQL Server 2016, 2016row-level SQL Server 2016 has a new function called Row-Level Security, which generally refers to the Security policy of the Row version (I used to be an English scum _ (: Dirty "dirty

Use the SQL Server database email service for monitoring and warning. Background More and more enterprises and companies require 7x24 database monitoring. Generally, third-party platforms are used to monitor and remind emails and text messages. A

Installation and configuration methods for SQL Server official edition graphic tutorial, Server2016 installation and configuration Install SQL Server official edition Today, I finally have time to install the official SQL Server version. It takes a

Two Methods for batch data import in SQL Server databases: SQL Server During the implementation of software projects, data import has always been a headache for the project staff. In fact, many data import methods are integrated in SQL Server. Some

Resolve the SQL Server to focus on the removal (Bookmark Lookup, RID Lookup, Key Lookup), bookmarkrid Preface The previous sections focus on basic content. In this section, we will talk about index performance optimization. When processing big data,

MySql update optimization policy and mysql update policy Simulation Scenario 1: Add several fields to the structure adjustment of a table in the database and then refresh the previous data. The refreshed content matches an existing field url, then,