SQL Server

--How to use: Execute in a stored procedure that gets a list of queries, and specify parameters on the line--exec listpage @SQL, @PageSize, @PageNo, @OrderStr, @OrderType--@SQL query statement--Number of @PageSize data--@PageNo Current

All server roles are "fixed" roles, and they exist from the start-all of the server roles you will have have existed since the moment the SQL Server was installed.RoleCharacteristicsSysadminThis role is capable of performing any operation on SQL

1, sysobjectsThe System Object table. Objects that hold the current database, such as constraints, default values, logs, rules, stored procedures, and so onIn most cases, the two columns that are most useful to you are sysobjects.name and Sysobjects.

Original: SQL Server submitted read snapshot test1. Open the database submitted read snapshot option2. The database has been submitted to read the test in snapshot modeA) test table testsb) Turn on transaction 1, update data C2 = ' 200 ' (not

Original: SQL Server post-removal feature rollupFeature Update removal rollup Field type ntext,textimagenvarchar (Max),varchar(maxvarbinary(maxofvarchar( Max),nvarchar(maxvarbinary (MAX) data.Tip: Stay tuned for ongoing updates

Original: SQL Server group Query the time difference between two adjacent recordsFirst, we use two records from the table in the database to elicit problems, such asThese are the table data for a record operation record. OrderID is the self-growing

Enable SQL Server Enable manager, take 2008 as an example 1. Set Table information description Select the table you want to set, right-click on "Properties" 、 Select Extended Properties

SQL Server System database function-sqlserver,tempdb, record, master, number, size,-North network-training　　System DatabaseSQL Server's system database is divided into: master, model, msdb, and tempdb, these four databases do their job in SQL Server,

The remote server reached the maximum number of connections, in order to achieve a remote restart, so think of the SQL Statement command to implement this function, but the specific command format to forget, found a little information tutorial . net/

Create function [dbo]. [Getchildworkerextension](@ChildId int)Returns nvarchar (100)AsBegindeclare @ret nvarchar (2000)Set @ret = ' 'Select @ret = @ret + '; ' + (Case relationshipWhen 1 Then ' father 'When 2 Then ' mother 'When 3 Then ' Grandpa

Transaction concepts:A transaction is a mechanism that contains a set of database operations commands, and submits or revokes all commands as a whole to the database.This set of commands is either executed or not executed, so the transaction is an

In some of the business, such as sending text messages, mail, we often use a table to store the data to be sent, from the background multiple threads constantly read from the table to send data to send, the completion of the transfer of data to the

First, the necessity of database designIn the actual software project, if the system needs to store a large amount of data, the table needs to be designed more, the relationship between table and table is more complex, then we need to standardize

1. http://www.cnblogs.com/CareySon/archive/2013/05/04/PlanCacheInSQLServerPart2.html (Execution plan cache)2. http://msdn.microsoft.com/zh-cn/library/ms190730 (Enable lock memory page)3.

SQL Server Export DatabaseNAVCAT for SQL Server open connection, open database, right--data transfer, General tab--mode SELECT dbo, target select connection (select your new library) or file (export your desired SQL file location), click StartStuff

1.viewing collationsSelect SERVERPROPERTY (' collation ');2.Specifying the collation of a columnALTER TABLE T2Add Y nvarchar (+) collate chinese_prc_ci_as;Go---------------------------------------------------Chinese---The meaning of "body word"

Method: 1Sys.indexesindex_id = 0: Heapindex_id = 1: Clustered indexindex_id =2 ...: Nonclustered indexes-------------------------------------------------------------------------------------Example:CREATE TABLE Student (ID int NOT NULL,Name nvarchar (

SQL Server looks at the resources that are consumed, as follows:you can use SQL to quickly locate Cpu,io in a database that consumes a higher cost:1. Locate the process information that consumes Cpu,io the

After SQL Server R2 is installed, you find that the server collation is incorrect and you do not want to reinstall SQL Server.Assume that the server collation for the current default instance is: Chinese_prc_ci_as, to be modified to

SQL Server ignores the index prompt. SQL Server ignores the index When we want a query statement to use an index, we usually add an index prompt to the query statement, as shown in the following figure: Copy codeThe Code is as follows: SELECT id,