SQL Server 2

First, create a data table

1. Connect to the server;

2. Right-click the Tables node and select New table, which is:

3. In the Table Designer that pops up, enter the column name of the table, the data type selected, and whether to allow Nulls, that is:

Second, Import data table

1. Right click on the table name, pop-up menu, select "Import Data" in "task", that is:

2. In the SQL Server Import and Export Wizard dialog box that pops up, click Next, which is:

3. In the "Select data source" screen that pops up, select the data type in the "data source", i.e.:

4. Click Next to go to the "Select Target" screen and select Import data target.

Third, export the data table

Similar to importing data tables

1. Right-click the table name, pop-up menu, select "Export Data" in "Tasks", i.e.:

2. In the SQL Server Import and Export Wizard dialog box that pops up, click Next, which is:

3. In the "Select data source" screen that pops up, select the data type in the "data source", i.e.:

4. Click Next to go to the "Select Target" screen and select Export data target.

Third, modify the data table

1. Add and Remove fields

2. Renaming a data table

3. Delete Data Sheet

IV. Maintenance of Data sheet records

1. Inserting data information

(1) Right click on the table name and select "Edit Top 200 lines", i.e.:

(2) Editing in the Data editing window

2. Modifying data information

In the Data Editing window, make changes, namely:

3. Delete data information

SQL Server 2