Theoretical understanding of SQL server2000

I have been studying data for some time, but the use of SQL Sever is still very little. Today I conducted a theoretical study on one of its application software, SQL Sever2000.

#First of all, I will give you a picture to get a general understanding of its overall context.

Through the overall perception, the main functional module of SQL sever exists in the operation module. The operating environment and T-SQL language both serve the operation module. Help the software provide better services and realize its own functions.

1. Operating environment

##· The system directory file is automatically saved to the installation directory when the software is installed. It is like the directory of a book, recording the overall context of a system; since the software is used to serve the database, of course, the user Have a simple understanding of the database. On the one hand, the self-built database records all user login information, and on the other hand, it provides users with database examples and templates for developers who have not been exposed to the software to learn and use.

The most important and commonly used part of the environment module is the tools. Based on data, it provides basic services of importing and exporting data and backup and recovery; based on management, it provides servers Manager, used to start the sql sever service; Enterprise Manager, an application that specifically manages the database; The most important application of the database must be applied to the network, and the network server is indispensable.

2. Specific operations

Compared with the learning of VB language, the entities of the operation Libraries, objects, tables, etc. are equivalent to the manipulated objects such as forms, modules, and various controls in VB. The process control, triggers and functions in the process module can all be abstracted into functions, and a set of codes are integrated together to form a function block to achieve a certain function. T-SQL language defines temporary variables and constants for each function, and builds three major structures to form virtual functional functions to provide operations such as addition, deletion, modification, and query of database entity sets. Different from vb, every time you log in to SQL The sever2000 interface must be logged in through an account and password, so appropriate security mechanisms must be established.

Based on the learning concept that existence must be reasonable, the database involves a large number of data operations. If it is applied to enterprises, it must have certain Only confidentiality measures can ensure core competitiveness!

3. T-SQL language

##T-SQL language exists independently of software, just like vb, providing the possibility of linking external programs. Although it cannot be applied to different application development environments like Java, it Links between necessary programs are essential! For example, we use VB to design the computer room charging system, and the student information management system will use SQL language to establish corresponding links!

Summary: A good compilation environment realizes basic functions through a basic operating interface, encapsulated in an operating environment; establishes an interface with the outside world through a unique programming language, Software designed using other development software is connected through these interfaces to form large-scale application software! This not only helps managers form a clear division of labor in the software design process, but also helps various modules to be carried out at the same time, speeding up software development efficiency! The above is the theoretical understanding of SQL server2000. For more related content, please pay attention to the PHP Chinese website (www.php.cn)!