SQL Server

SQL Server provides three recovery models: L simple recovery: allows you to restore the database to the latest backup. L full recovery: allows you to restore the database to the fault point state. L large-capacity log record recovery allows

Reduce database deadlocks! Here are some tips on how to avoid deadlocking on your SQL Server: Ensure the database design is properly normalized. Have the application access server objects in the same order each time. During transactions,

Create procedure pages @ Tablenames varchar (200), -- table name, which can be multiple tables but cannot be aliases @ Primarykey varchar (100), -- primary key, which can be null, but this value cannot be blank when @ order is null @ Fields varchar (

Description: datediff (datepart, startdate, enddate) returns the number of datepart intervals. Select datediff (YY, '2017-06-1 ', getdate () -- calculate the number of yearsSelect datediff (Q, '1970-01-1 ', getdate () -- calculate the number of

Problem description: When SQL Server is started, the system prompts that the service cannot be started due to login failure. ---------------------------------------------------------- Cause: Security When installing SQL Server, the default

ArticleDirectory I. Overview 2. Database Separation Iii. Additional database I. Overview SQL Server provides backup and recovery methods for "detach/Attach" databases, "backup/restore" databases, and duplicate databases. This

After creating a table on SQL Server, you often need to change the design of the table. If you have any questions, the system will prompt "you are not allowed to save the changes. You must delete the changes and recreate the following tables. The

In Select The alias created in the list cannot be in Select Used in the clause executed before the clause. In fact, expression aliases cannot be used Select Other expressions in the list. This restriction is caused SQL Another unique feature

When a query arrives at the database engine,SQL ServerPerform two major steps to generate the expected query results. The first step is query compilation, which generates the query plan, and the second step executes the query plan.   SQL Server 20

In our daily operations, we have to insert multiple records to a table in the database at a time, but the first thought is to copy and paste n multiple repeated insert into statements, in case an error occurs when a semicolon or multiple Commas are

There is a news data table tb_news, which has the news_id int and news_type int fields. The former is the primary key and the latter is the ID of the news topic. The requirements are as follows: Given a string a_right, the string contains multiple

Every time I read every time I forget .. turn from http://bbs.nankai.edu.cn/ " When designing a database, we are used to setting the Data Type of the field storing strings to Char, varchar, nchar, and nvarchar. The text and ntext types are

function name function host_id return the ID of the server-side computer host_name return the name of the server computer db_id ID of the returned Database ID db_name

Char (or nchar) and varchar (or nvarchar) are the most common data types used to store character data in databases. Because they have the same majority of features, when selecting which type of character data to use, There may be some questions.

-- Create a testCreate Database DBGo -- Normal backupBackup database dB to disk = 'C: \ 1. Bak' with formatBackup log dB to disk = 'C: \ 2. Bak' with formatBackup log dB to disk = 'C: \ 3. Bak' with formatBackup database dB to disk = 'C: \ 4. Bak'

  Write this articleArticleIt was not planned and has never been used to full-text indexing. Occasionally preparing lessons. Suddenly inspired. You decided to record the process of creating and using full-text indexes for future use. As for the

Table value parameter (ADO. net) in SQL Server 2008) Table value parameters provide a way to applyProgramTo SQL Server, instead of multiple round-trips or special server logic.You can use table value parameters to encapsulate data rows in client

1. A trigger is a special stored procedure and cannot be explicitly called. It can only be automatically activated when an insert, update, or delete operation is performed on a table. Therefore, triggers can be used to implement complex integrity

Instance 1: Select a. name columnname, c. name as typename, case when a. is_nullable = 0 then 'Not Null 'else' null' end as nullable, .*From sys. columns a, sys. objects B, sys. types cWhere a. object_id = B. object_id and B. name = 'table name' and

  1. What is a view? 2. Why view; 3. order by in the view; 4. Refresh the view; 5. Update the view; 6. view options; 7. Index View; For more information, see the "Why use View" section in "View (top)" of SQL Server as required. 5. Update the view A