SQL Server

https://www.douban.com/note/559596669/Format is similar toCREATE PROCEDURE YourprocedureAsBEGINSET NOCOUNT on;Begin TRY---------------------Start catching exceptionsBEIN TRAN------------------Start a transactionUPDATE A SET a.names = b.names from

Knowledge sectionSystem database: SQL Server R2 includes four system databases by default, master, model, msdb, tempdb, respectively. The master database is used to record all system-level information, all login accounts, and system configuration

installation SQL SERVER Database1. Install . NET on the R2 before installing SQL. 2. after the installation is complete, the installation center interface appears, select Installation, options, select a new installation or add to an existing

Original: SQL server-focus Row_number VS TOP N PerformanceObjectiveSorry, guys, since August, I've been working on writing EntityFramework 6.x and EntityFramework Core 2.0 books, so I've been missing out on the management of blogs lately, and I'll

Insert a row of dataINSERT [into] table name [(column name)] VALUES (Value list)Precautions:(1) Each time a row of data is inserted, it is not possible to insert only half a row or a few columns of data inserted data is valid will be checked

Through the system's stored procedure sp_who or Sp_who2 can find all the lock information, but do not see which table, what statementWhen using sp_who or Sp_who2 to find the lock information, there is a SPID information, you can use the following

Select number from Master. Spt_values with (nolock) where type= ' P '/** explained: Master. The corresponding Number field value for the Spt_values table's field value is p from 0-2047*/--1. Converting a string to a column shows if OBJECT_ID (' TB ')

Query the statement that is currently executing:1 SELECT 2Der.[session_id], Der.[blocking_session_id], 3 Sp.lastwaittype,sp.hostname,sp.program_name,sp.loginame,4Der.[start_time] as 'Start Time', 5Der.[Status] as 'Status', 6Dest.[text] as

data Query-column aliasesUse as to name a columnSELECT SCode as student number, SName as student name, saddress as student address from Students WHERE saddress <> ' Henan Xinxiang 'Use = to name the columnSELECT name = Firstname+ '. ' +lastname from

the If-else statement in//sqlIF (condition)BEGINStatement 1Statement 2... ...ENDELSEBEGINStatement 1Statement 2... ...ENDExample:IF (@score > 85)PRINT ' Exam level: ' + ' excellent 'ELSE IF (@score > 70)PRINT ' Exam level: ' + ' good 'ELSE IF

1--Create a test table2 CREATE TABLE [dbo]. [Testrows2columns] (3[Id] [int] IDENTITY (1,1) not NULL,4[UserName] [nvarchar] ( -) NULL,5[Subject] [nvarchar] ( -) NULL,6[Source] [Numeric] ( -,0) NULL7 )8 GO9 Ten--inserting test Data One INSERT into

There are city library tables in the database, including countries, provinces and cities.Example: in Guangdong province (including Guangdong province itself), find the name of "Guangzhou" recordFirst, the conditions in Guangdong province are:

Really helpless obviously a lot of things clearly I just write a website let me go to the database don't say refuelingCreate statement1 UseTig2 GO3 Create Trigger [Trigger Name] on [Table name]4 [Trigger Conditions]( for Insert/ for

Quoted https://www.cnblogs.com/JiangLe/p/4007091.htmlPre-Preparation:CREATE TABLE Employee (ID int NOT null primary key,Name nvarchar (4),credit_card_id varbinary (max)); ---Be careful with this data type.GoDescription: The index on this table will

If you execute an SQL statement without parameters, SQL Server internally parameterize the statement to increase the likelihood of matching it to an existing execution plan. This process, known as simple parameterization (in SQL Server 2000, called

In the maintenance project, we often encounter problems with index maintenance, through the statement, we can determine whether the index of a table needs to be rebuilt.Execute the statement: Parse the index of the table firstIndex establishment of

I configured the following:One months perform a full backup database and delete the backup file three months ago. Perform a differential backup every day, deleting one months of money back up files.1. Management-Maintenance plan right-new

SQL Server full-text search function introduction, full-text search function Introduction Full-Text Search of SQL Server is a Text Search function based on Word Segmentation and relies on Full-Text indexing. Full-text indexes are different from

Definition, modification, and deletion of stored procedures in SQL, and SQL stored procedures 1. Storage Process Classification System stored procedures Local Stored Procedure (User-Defined) Temporary stored procedures (local [#] and global [#

Mybatis collection Multi-condition query implementation method, mybatiscollection Implementation of mybatis collection Multi-condition Query Preface: The business needs to return Nested Sets through mybatis query. It is too troublesome to query