Tutorials to .com

Tutorials to .com » Database » Sqlserver » Microsoft SQL Server Tutorial

Microsoft SQL Server Tutorial Articles


361: Application of full-text search (1)
Application of full-text search (1) Basic knowledge 1. SQL Server7 version of DeskTop not full-text retrieval. 2. A table can only have one full-text retrieval. 3. To be retrieved must have a separate table of the unique index. 4. Full-text ind...

362: Raiders wide security planning SQLServer
SQL Server-wide security planning Raiders To improve the SQL Server 7.0 series of security mechanisms to achieve the process, Microsoft has established a flexible and powerful security management system, which users can access SQL Server and databa...

363: Follow me MSSQLServer (9)
I have learned with MS SQL Server (9) (Ix) datetime and interval datetime and interval time are two types of related data. Their role in the following areas: to create or change records of a particular record, the time when a running record of tim...

364: Follow me MSSQLServer (8)
I have learned with MS SQL Server (8) (H) the type of numerical data SQL92 standard definition of a number of basic data types, which are SQL database based on a variety of data types. In the "string data type," a text, we have discussed ...

365: Follow me MSSQLServer (7)
I have learned with MS SQL Server (7) (Vii) the deletion of data from the sub-table <BR> In this article I would like to describe how to delete rows from the table, it is necessary to delete these out at the same time, dependent on other form...

366: Follow me MSSQLServer (6)
I have learned with MS SQL Server (6) (Vi) the type of serial data of SQL data type determines the contents of a field in the database will be how to deal with, storage and display. The definition of a standard SQL92 data types, the purpose is to e...

367: Follow me MSSQLServer (5)
I have learned with MS SQL Server (5) (E) create and modify forms <BR> once again welcome you to SQL (Structured Query Language) based on series of tutorials. This article will introduce the database definition language (DDL) used to create d...

368: Follow me MSSQLServer (4)
I have learned with MS SQL Server (4) (D) a number of forms <BR> query across multiple forms of data combination, and sometimes it is difficult to figure out which one to use SQL syntax. I will be here on a number of forms will be combined in...

369: Follow me MSSQLServer (3)
I have learned with MS SQL Server (3) (C) the combined use SQL to query <BR> do you have in order to obtain the required information and repeated inquiries? Sub-option, also known as sub-query, perhaps it is you are looking for. This SQL func...

370: The pattern matching SQLServer
SQL Server in the pattern matching Date: 2004/11/17 Email: de_euler-david@yahoo.com.cn Have any questions, please contact me:) SQL Server Books Online search above like, found a few %,_,[],[^] contain wildcards. Such as: select * from mybbs whe...

371: Follow me MSSQLServer (2)
I have learned with MS SQL Server (2) (B) SELECT statement options <BR> follow me SQL is divided into three parts, which cover the basic knowledge of SQL standards. In the last article we discussed a number of database terminology and four ki...

372: Follow me MSSQLServer (1)
I have learned with MS SQL Server (1) (A) data query <BR> not to mention whether you are engaged in the work program or do not intend to learn SQL, can be a matter of fact almost every developer will eventually hit it. You do not need most of...

373: SELECTTOPN problem
SELECT TOP N problem Hi, everyone: affixed to the discussion of this issue of SELECT TOP N. Computer is now a part-time, the development of ASP applications. In a recent commercial projects have such a demand: the user query, only in accordance w...

374: The use of stored procedures usedatabase
The use of stored procedures use database Its well known.Microsoft SQL Server is not allowed in stored procedures or triggers in the database using the USE statement to change the current database. How do? Can, of course, the direct use of [databa...

375: Sqlserver limited number of memory to use the most appropriate
Sql server using the memory limit in the number of the most appropriate If a single Data Server, memory is a good idea to remove the system memory to run around about 20M, and the rest left to Sql Server ...

376: SQLServer Deadlock causes and solutions
SQL Server in deadlock causes and solutions In fact, most all of the deadlock is a deeper reason: the performance of a competition for resources: A visit to a user table A (lock the table A), then a visit to Table B Visit another user B Table B (...

377: SQLSERVER cycle write data directly
SQL SERVER cycle to write data directly declare @ i int set @ i = 1 while @ i <30 begin insert into test (userid) values (@ i) set @ i = @ i +1 end ...

378: Table SqlServer index maintenance
Sql Server table to maintain the index - The first step: to see if the need to protect, view scan density / Scan Density is a 100% declare @ table_id int set @ table_id = object_id (table name) dbcc showcontig (@ table_id) dbcc dbreindex (table...

379: SqlServer practical skills to operate a small collection of
Sql Server practical skills to operate a small collection of (A) suspend the operation or sp in the patch installed Sql prompted when the installation hangs before the operation, asked to restart, restart often useless here, the solution: To HKEY_...

380: SQL step by step (3) data retrieval
SQL step by step (3) data retrieval SELECT statement in the SQL in the database normally used for retrieval, or retrieval to meet the conditions of your data set, the following SELECT statement is a simple format: select "column1" [, &qu...


Page 19 of 39
[1]   [2]   [3]   [4]   [5]   [6]   [7]   [8]   [9]   [10]   [11]   [12]   [13]   [14]   [15]   [16]   [17]   [18]   [19]   [20]   [21]   [22]   [23]   [24]   [25]   [26]   [27]   [28]   [29]   [30]   [31]   [32]   [33]   [34]   [35]   [36]   [37]   [38]   [39]