Help to build a database, how to build a business data database

Use SQL Server 2000 Enterprise Manager, right-click on "Database", then select "New", enter "JZ ACC" in the database name, click OK to create a database named JZ ACC, then open SQL Server Query Analyzer, and switch to database JZ ACC, then open JZ with Notepad, copy the SQL** in it to SQL Server Query Analyzer, and execute it,Hehe,Hope it helps,

Once you have installed SQLSer, go to Enterprise Manager --- Tools - Query Analyzer - General. The ** in the sql file, copy it in, click the green triangle key, it is executed, and it's OK.

If yours. There is no library in the SQL script, only the table is created, then you can create a new database in SQL Enterprise Manager, the options are default, and then - Tools - Query Analyzer - Repeat **, point execution!

I've got a bag for you :

Inside are sql2000 and sqlsp3 patches.

SQL Tutorial:

In fact, the use of SQL2000 has been described in sufficient detail as it provides an online series.

I can't see your link address anymore.

1 First of all, open our access program, the way to open it is to click on Start – All Programs.

2 Find the Microsoft Office folder among all programs and open it.

3 Find Access and click Open.

4 In the access interface, click file-new.

5 On the right side of the Create dialog box, select Interface Version and select Empty Database.

6 Select a location where to store the file, then specify the database and click Create.

7 So we created a database.

<>1. Clarify the high-level needs of the enterprise;

2. Define a data model, including all data types and relationships;

3. Define data integrity constraints;

4. Define the physical level;

5. For each question about the function, define a user interface to perform the task, and write the corresponding user program to implement the user interface;

6. Create a database.

An enterprise database is a collection of data that stores, organizes, and manages enterprise data according to the data structure, and can be simply defined as a collection of all data that is stored together in a certain organizational way, has a certain relevance, and is of common concern to users.

You can use the information management platform to record all the case information, centralize management, and it is more convenient to consult.

Take Hua Chuang information management platform as an example to illustrate the functions of this type of platform:

1. For non-professionals, no programming is required, allowing users to freely build tables, customize data formats, and manage various data. Whatever you want to manage, you can create a table. For example, in the case data table, set the following fields:

Project Name, Design Requirements, Author, Start Date, Finish Date. etc., which are used to record general information; Set up several attachment fields for uploading documents such as word, excel, and **.

2. After creating the table, you can set the login account and permissions, and you can enter data and share data, as for the operation interface, data storage and other details are automatically completed by the platform.

3. Support multi-user access at the same time, with perfect permissions, and the addition, deletion, modification and viewing rights of all kinds of personnel can be controlled in detail.

4. It not only supports computer access, but also supports direct access to mobile phones and ipads, so that you can record and check data whenever and wherever you are.

5. It has the function of automatic reminder, which can automatically send email notifications, mobile phone text messages, and internal text messages in the system, which can be used for birthday reminders, various expiration reminders, etc.

6. Support the import and export of excel data, and the existing case data does not need to be entered again, and can be directly imported into the system; The data in the system can also be exported to Excel or Word again.

Select the Programs ManagementSqlServer 2008 SqlServerManagementStudio command in the Start menu to open the SqlServerManagementStudio window and establish a connection using Windows or SQL Server authentication.

In the Object Explorer window, server, and then select the Database node.

Right-click the Database node and select the New Database command from the shortcut menu that pops up.

After performing the above operations, the New Database dialog box will pop up. In the dialog box, there are three options on the left side, which are [General], [Options] and [Filegroup]. After completing the setup meeting in these three options, you will complete the database creation work, and enter the name of the database you want to create in the Database Name text box.

For example, here it starts with "New Database".

In the Owner text box, enter the owner of the new database, such as sa. Depending on the usage of the database, select the Use Full-Text Index check box.

Include two rows in the Database Files list, one for the database file and the other for the journal file. Add or delete database files by clicking the Add and Delete buttons below.

Switch to the Options Page, where you can set the collation, recovery mode, compatibility level, and other properties of the database.

Switch to the [File Group Pure Boredom] page, where you can add or remove file group covers.