SQL Server

--select Right (@strReplace,-2) /*Loop replaces a stringSet @strReplace = ' City; district; company ' characters to be replaced, separated by semicolonsSet @strTest = ' xiamen Simin District XXX Information Technology Co., Ltd ' the original string

To enable automatic seeding of a secondary replica on an existing availability groupExecutes on the primary replicaALTER availability GROUP [] MODIFY REPLICA on ' ' with (seeding_ MODE = AUTOMATIC) GOThe previous command forces the database to

The length of the char type is immutable in SQL Server, and the length of the varchar is variable.When depositing data:If the data type is char, when a fixed length of a field is defined, if the length of the stored data is less than the length of

With nodesAs (SELECT * from users as child where Child.id = 6UNION ALLSelect par.* from users as parINNER JOIN nodes as RC on par.id = Rc.pid)SELECT * from the users where ID in (Select ID from Nodes n)-- //With nodesAs (SELECT * from users as par

CREATE TRIGGER [dbo]. [Updataalarmlevel]on [dbo]. [Alarm_alarm_info]After inserts, update– after updating and insertingAsBEGINIf update (transfernum) or update (Potentialloss) – event triggered if the Transfernum or Potentialloss two column in the

It's on the Internet. To set the SQL Server network configuration-"SQLExpress" protocol-"TCP/IP" in Server Configuration Manager I tried it.I do not know whether to test the settings of the time to change what parameters to the whole good.Now the

Constraint definitionsFor a database, the integrity constraints of the basic table are divided into column-level constraints and table-level constraints:Column-level constraint conditionsA column-level constraint is a constraint on a particular

Ø Index1. What is an indexAn index is a list of data in a data table and a corresponding storage location that can be used to increase the speed of finding data in a table or view.2. Index classificationThe indexes in the database are divided into

A trigger is a special type of stored procedure that differs from the stored procedure we described earlier. Triggers are triggered primarily by an event that is automatically invoked to execute. The stored procedure can be called by the name of the

exec sp_configure ' show advanced options ', 1 reconfigureexec sp_configure ' Ad Hoc distributed Queries ', 1 reconfigureSELECT * into t_system_organization_bak_20180308From OPENROWSET (' SQLOLEDB ', ' 10.***.***.***, port; ' User name '; ' Password

When I recently encountered a group sort query in MySQL, I suddenly found that there was no sort of row_number () over (partition by colname) in MySQL.And since there is no ranking function in MySQL similar to row_number (), rank (), Dense_rank ()

Sometimes you will need the function of SQL result set row to columnFor SQL row-to-column (PIVOT) and column-changing (UNPIVOT), refer to Https://www.cnblogs.com/linJie1930906722/p/6036714.htmlBut sometimes it takes a dynamic column and the data

1, point SQL Server error log, right-click, configure, limit the number of error logs, such as 6 limit log growth2. Then run the command:EXEC Sp_cycle_errorlog;The purpose of this command is to archive the current log, and then create a new log.

Transferred from: http://www.maomao365.com/?p=5586Summary:The following focuses on SQL Server table design and scripting, related specifications ———————————Data table field type selection:Character type Select the appropriate varchar nvarchar

STEP1: Open the database and select the database where you want to import the target tableSTEP2: Task---Import dataStep3: The data source selects Excel, selects the corresponding path, the version, and whether the first row is the header row.STEP4:

SQL Server submits a user-submitted DML statement that, through a series of optimizations, produces a scenario that can be identified and efficiently "responded" by SQL Server using the Ctrl+m (actual execution plan) in Ctrl+l (estimated execution

Recently encountered a problem:You want to restore SQL Server high-backup data to a lower version of SQL Server, but it is not possible to directly restore the database in SQL Server, so after a series of consulting to summarize the available

1, first confirm the database relationship between the use of the code page, is consistent2, if the above method does not work, change the data type in the designer, the string type to nstring type, Chinese is not garbled3. The type of text in the

4.2.4 SQL Server database filesSQL Server stores the data in a data file and stores the transaction records in a transaction-log file. If you assemble them together with a logical database name, the files are the databases. A SQL Server database can

1. number of records in each tableSelect A.name as Table name , Max (b.rows) as number of record strips From sysobjects A, sysindexes bwhere a.id=b.id and a.xtype= ' u 'GROUP BY A.nameORDER by Max (b.rows) desc2. Total number of recordsSelect SUM(