A theoretical understanding of SQL server2000

The data has been learning for some time, but the use of SQL Sever is very few, and today, one of its application software SQL Sever2000 a theoretical study.

First, pay a picture to have a general understanding of its overall context.

Through the overall perception, SQL Sever main function module exists in the Operation module, the running environment and T-SQL language both serve the Operation module, help the software better service, realize its own function.

First, the operating environment

· system catalog files are automatically saved to the installation directory when the software is installed, like a book directory, the whole context of a system is recorded; since it is used for software services to the database, of course, to let users have a simple understanding of the database, the self-built database on the one hand to record all the user login information, On the other hand, the user database samples and templates are provided for use by developers who are not exposed to the software.

The most important and most common parts of the environment module are the tools, which are based on the data provided to the import and export data and the backup Recovery basic service; management-based Server Manager for starting SQL Sever services; Enterprise Manager, Application to manage database; The most application of the database is bound to be applied to the network, the networking server is essential.

Second, the specific operation

Compared to VB language learning, the operation of the entity library, objects, tables and other equivalent to the VB form, modules and various controls and other manipulated objects. Process control, triggers, and functions in a process module can be abstracted into functions that integrate a set of code together to form a functional block for the implementation of a function. The T-SQL language defines temporary variables, constants, and constructs three major structures to form virtual function functions to provide additions and deletions to the database entity set. Different from VB is every login to the SQL sever2000 interface through the account and password login, so that the appropriate security mechanism must be established.

Based on the existence of a reasonable learning concept, the database involves a large number of data manipulation, applied to enterprises, must have a certain degree of secrecy to ensure the core competitiveness!

Third, T-SQL language

The T-SQL language is independent of the software, like VB, for external program links to provide the possibility, although not like Java can be applied to different application development environment, but the necessary links between the program is necessary! For example, we apply VB Design Room charge system, student information management system will use the SQL language to establish the corresponding link!

Summary: A good compilation environment through the basic operating interface to achieve fundamental functions, packaged in an operating environment, through a unique programming language and the outside world to establish interfaces, in the use of other software software design through these interfaces to establish a connection together to build large-scale application software! This not only facilitates the management of the software design process to form a clear division of labor, but also help a variety of modules at the same time, speed up software development efficiency!

A theoretical understanding of SQL server2000