Tutorials to .com

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

Microsoft SQL Server Tutorial Articles


501: Application of the cursor
In the preceding sections, we detail how the cursor declaration, read data from the cursor, as well as the closure of the method of the release of the cursor. Now we will give a few examples of the cursor so that readers have a more comprehensive un...

502: Database connection query
Database table of all the different data storage, users often need more than data in the table below to mix, to extract the information needed. If a query needs to operate on a number of tables, known as join query. Connect with the results of inqui...

503: Modified to delete the cursor position
Usually we use the cursor to the basis of the table from the retrieval of data in order to achieve the processing of data. However, in some cases, we often want to modify the data in the cursor, that is, positioning the cursor to update or delete th...

504: Application of SELECT statement
From the beginning of this section, we will use a large number of examples of the application on the SELECT statement. First of all, from the simplest and most commonly used to start the single-table query. 10.2.1 select out (1) query SELECT claus...

505: The closure of the release of the cursor
13.5.1 Close the cursor 1, using the CLOSE command to close the cursor In the processing of data after the cursor must be closed to release the cursor result set and position data to the data recorded on the lock. CLOSE statement to close the curs...

506: Data Query - SELECT statement
Database is more convenient for the effective management of information and the people there, I hope the database can provide the required information. Therefore, users, data query is the most important functions of the database. This chapter will d...

507: Cursor to read the data in the
When the cursor was opened successfully, would be in line by line from the cursor to read the data to perform correlation processing. Read data from the cursor FETCH command used. The syntax rules are: The meaning of each parameter as follows: ...

508: Default Database
Default (Default) is entered by the user to record specific data do not specify the column data is automatically inserted. Default object with CREATE TABLE or ALTER TABLE command when operating table DEFAULT option specifies the default value of the...

509: Open cursor
Open the cursor in a statement after the cursor, if the data read from the cursor must be open cursor. Open a Transact-SQL server cursor using the OPEN command, the syntax rules: OPEN (([GLOBAL] cursor_name) | cursor_variable_name) Each parameter ...

510: Database rules
Rule (Rule) is stored in the database table columns or user-defined data type of the value of the provisions and restrictions. Rules are stored in a separate independent database objects. Rules and their role or user-defined data types are independe...

511: Cursor declaration
Each cursor must have four components of the four key part of the order must comply with the following; 1.DECLARE cursor 2.OPEN cursor 3. FETCH from a cursor in the message DEALLOCATE cursor 4.CLOSE or usually we use a cursor DECLARE statement t...

512: Data Integrity Overview
The data in the database is imported from the outside world, and data entry for various reasons, would enter invalid or incorrect information. To ensure that the required input data, has become the database system, in particular the relationship bet...

513: Cursor, the cursor type of the advantages and
The first part of this chapter provides the application of MS SQL SERVER cursor on the cursor should have the necessary knowledge and all kinds of grammar. From which readers can understand the merits of the cursor, type, role, learning how to defin...

514: Create and use charts
Chart is specific to a SQL Server database objects, which provides to users an intuitive way of managing database tables. Through the chart, the user can directly create, edit relationships between database tables, you can edit the attributes of tab...

515: Management triggers
If you want to show the role of trigger in the form of the table exactly what the operation, we must view the trigger information. In the MS SQL Server, there are many ways to view the trigger information. In this section we will introduce two types...

516: Index adjustment Wizard
8.5.1 Indexing and system performance Indexing can speed up the speed of data retrieval, but it will insert data, delete, and update slow. In particular, cluster index, data is stored in logical sequence in accordance with a certain degree of physi...

517: Advanced Application trigger
Application of the trigger often encounter this situation, was trying to update triggered flip-flop associated with the objectives of the original table, so that flip-flop was to trigger an endless loop. For that case, different database products pr...

518: Delete index
8.4.1 Using Enterprise Manager to delete the index in the Enterprise Manager can be shown from Figure 8-9 or the index of the management of the dialog box shown in Figure 8-14 Table Properties dialog box, select the index you want to delete, and the...

519: Application of Flip-Flop
In the above we discussed the advantages and disadvantages of flip-flop, flip-flop working principle and the creation of specific methods. Next, we will address the complexity of the different applications of the flip-flop. 12.9.1 Application of fl...

520: View and modify index
8.3.1 Using Enterprise Manager to view, modify the index in the Enterprise Manager, select the database to view, and then choose the mission board "Tables & Indexes" page box will be displayed in the mission board to all users of this ...


Page 26 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]