SQL Server

The table is as follows: Obtain the following results: Solution Use xml Conversion The Code is as follows: Copy codeThe Code is as follows:Create table body ( ID int, BODY nvarchar (20) ) Go Insert into body VALUES (1, 'aaa ') Insert into body

SQL Server:Copy codeThe Code is as follows:Select top n * From TABLE Order By NewID ()View plaincopy to clipboardprint?Select top n * From TABLE Order By NewID () Select top n * From TABLE Order By NewID ()The NewID () function creates a unique

1. OUPUT parameter Return Value Copy codeThe Code is as follows:Create procedure [dbo]. [nb_order_insert] (@ O_buyerid int,@ O_id bigint OUTPUT)ASBEGINSet nocount on;BEGINInsert into [Order] (o_buyerid)VALUES (@ o_buyerid)SET @ o_id = @

I. insert statements Insert is used to input data into the table. The syntax structure is as follows. Insert into table name VALUES (value 1, value 2,...) We can also specify the columns to INSERT data: Insert into table_name (column 1, column 2,.

How to restore a backup from a backup device (Enterprise Manager)Restore a backup from a backup device Expand the server group and then expand the server. Expand the "Database" folder, right-click the database, point to the "all tasks" sub-menu,

There are too many places to use MSSQL, and many technical PCS also Install SQL Professional Edition, because it is used a lot, but everyone knows that SQL has a Super User sa, by default, this user is assigned to the fixed server role sysadmin and

Master The Master database stores all the databases on the SQLSERVER entity, and it is also a binder that holds the engine. If you do not use the primary database, SQLSERVER cannot be started. Therefore, you must carefully manage the database.

Misunderstanding #20: After the log backup chain is damaged, a complete backup is required to restart the log chain.ErrorTransaction Log backup backs up all transaction logs since the last transaction log backup (if there is no log backup, it starts

Misunderstanding #26: there is a real "transaction nesting" in SQL Server"Error Nested transactions do not seem to allow transaction nesting as their syntax shows. I really don't know why some people write code like this. The only thing I can think

Copy codeThe Code is as follows:-- PKSelect * from sys. key_constraints where object_id = OBJECT_ID ('tb ')-- FKSelect * from sys. foreign_keys where parent_object_id = OBJECT_ID ('tb ')-- Create a linked serverExec sp_addrole server 'itsv', '',

The solution is to add a sorting Field in order by ID desc, which may increase the speed a lot. The sorting field is different from the query field.Such as tableCopy codeThe Code is as follows:Create table [dbo]. [CMPP_SendCentre] ([Id] [int]

Database optimization includes the following three parts: Database optimization, database table optimization, and program operation optimization. This article is the first part.Optimization ①: add data files and set Automatic File growth (rough data

In this article, I will explain how to use SQL Server tools to optimize the use of database indexes. This article also involves general knowledge about indexes.　　 　　Common knowledge about Indexes 　　 Index is the biggest factor affecting database

The common basic points are as follows:1. There are two types of triggers: Data Definition Language trigger (DDL trigger) and data control language trigger (DML trigger ).DDL trigger: the user responds when the user modifies the database structure

Use T_ SQL to create a database TestSchoolCreate a student table TblStudentCreate Student Score Table TblScore q tScoreId (score id, primary key, automatic number), tSId (student number), tEnglish (English score), tMath (math score)Create the

First of all, I need to emphasize that this article aims to reveal the principle of recovering the deletion records of heap tables. What I have considered does not apply to every situation of everyone. I hope you will forgive me ~Many friends think

Misunderstanding #9: database file shrinking does not affect performance Error! The only condition that shrinking database files does not affect performance is that the TruncateOnly option is specified when there is space at the end of the file.

Misunderstanding 10. database images can be found immediately after a fault occursErrorThe database mirroring technology is widely publicized on the market. After a fault occurs, it can immediately detect the error and perform failover.However, this

Misunderstanding #14. After clearing the log, the related LSN will be filled with zero Initialization Error When the log file grows manually, automatic growth, and creation are performed, it will be filled in with zero initialization. However, do

Hello everyone, our database has been introduced. Here is a summary. We learned how to add, delete, modify, and query SQL statements in this section. query is our focus. We will take a look at SQL statements learned by SQL Server 2005, graphical