SQL Server

--Maintenance Database---- Trigger ----Overview：Note:a trigger is a special type of stored procedure，used to enforce business rules。 On invocation, triggers cannot be called directly by the user through T-SQL statements, as stored procedures do, but

1. Use the Back up task in SQL Server task to save as a *.bak file.2. In another server, restore database, if the database already exists, overwrites the previous data. If it does not exist, a database with the same name is created.Issues that occur

1: Add a Difference field, judge the Difference field to deleteDelete from (select Row_number () over (partition by code order by time DESC) as rows A, code, time from table) where a > 22: Query out more than 1 of the table data, query out the

1. Enter the installation center: You can refer to the hardware and software requirements, you can see some documentation2. Select the new installation mode to continue the installation3. Enter the Product Key: Use the demo key here4. In the

The previous company did not use the stored procedure to do the project, so the niche of the call to the stored procedure, use is also smattering, just the company has a large number of stored proceduresThis time, in order to maintain a consistent

Transferred from: http://www.cnblogs.com/hoojo/archive/2011/07/19/2110862.htmlA stored procedure in Transact-SQL, very similar to a method in the Java language, can be called repeatedly. After the stored procedure executes once, the statement can be

Transferred from: http://www.cnblogs.com/hoojo/archive/2011/07/21/2112559.htmlSQL Server Database DesignFirst, the necessity of database designSecond, what is the database designThird, the importance of database designIv. Data

Background: Recently modified a SQL Server table structure with large amounts of data, error "cannot modify table." Timeout time has arrived. The time-out elapses before the operation completes or the server is not responding. 】Resolution: Tools,

Http://www.2cto.com/database/201308/234728.htmlSQL Server transaction execution half error whether the entire transaction is automatically rolled backAs you know, SQL Server transactions are a single unit of work. If a transaction succeeds, all data

--cte recursive query if (object_id (N ' menu ') > 0) drop table menucreate Table menu ( name nvarchar () not NULL PRIMARY key,senior nvarchar (+) NULL); INSERT into MENU values (' file ', NULL), (' New ', ' file '), (' Project ', ' new '), (

. Environment preparationVirtual machines: ssag-bj-ad-01, ssag-bj-fc-01, ssag-bj-sql-01, ssag-bj-sql-02, ssag-sh-ad-01, ssag-sh-fc-01, ssag-sh-sql-01?. Primary domain ControllerSSAG-BJ-AD-01 Installing the server role Active Directory Domain

When SQL Server restores the database, it prompts, "because the database is in use, you cannot obtain exclusive access to the database", whether I restart the database, or restart the computer, the separation of the database, will not solve the

When we do query tuning for SQL Server, we often use option (Loop/merge/hash join) at the end of the statement or declare Loop/merge/hash directly before the join statement, To force SQL Server to use a particular type of join method. But there are

MysqlIn MySQL, you can use Limit to query the records of column m to nth column,Example: SELECT * FROM tablename limit m, nSql= "SELECT * from the users order by UserId limit" + (pageNow-1) *pagesize+ "," +pagesize;Get the data for each page after

Source code files1, what is a performance issue?If the existing resources do not reach the maximum throughput, the system cannot meet the reasonable expected performance, then it can be defined as a performance problem. Performance metrics include:

Reference article: Public number articlehas always misunderstood left and right in SQL, and always thought it was like this.SELECT from WHERE = 1To execute such a sentence:SELECT Left (Mobile,2fromWHERE=1SELECTRight (mobile,2 fromWHERE=1The

1.Execute sp_databases queries all current database approximate information (name, size, etc.)2.exec sp_helpdb [MySchool] Returns all the details of the database (database size, location, filegroup, owner, log size, location, etc.), displaying all

As a programmer, it's really hard to have any insight, that is, to some people who have just learned to program, hoping to give them some help!SQL Server is not too difficult to get started as a database for beginners to learn! In other words,

Distributed query for SQL Server: If a project requires two or more servers, and we have to remove the data from several servers, we must use distributed queries!Here are two concepts: Local data source, remote data Source!A local data source refers

A quick solution for SQL Server to establish a connection with the Server but errors occur during login. When I recently connected to a remote database on VS2013, I suddenly couldn't connect. when I ran the MSTest, QTAgent32 crash. Change to IIS