Database Development Foundation-SQL Server Control database service + database creation and management (add and revise)

Services that control the database:

Method One:

1. Windows+r Open cmd Open run

2. Input net start MSSQLserver start database service

Enter net stop MSSQLserver to shut down the database service

Enter net pause MSSQLserver to pause the database service

Input net continue MSSQLserver continue database service

Database creation and management (add and revise):

Open SQL Server 2008

Method Two:

1. Open Control Panel → management tools → services

2. Right-click to select

Database creation and Management:

Open Database

Method One: interface operation

1. Right-click database → new database → Enter database name

　

2. Right-click on the New Database (Lianxi) < table > Options → new table

3, enter the column name, data type and save, for example: School number, name, gender, age, address, score

4, right-click the new Table (student), you can view or edit, because there is no input information, all content is empty

5. Click < edit the first 200 lines > enter the information, click < select the top 1000 lines > view

6, increase the deletion of the check, you can click < edit the first 200 lines > to make additional deletion check

Method Two: Code manipulation

1, click < new query, open the right side of the interface

2, code new database Lianxi, check Click to execute, show that the command has been completed successfully

3, the database used at this time is not a new Lianxi database, you need to first use the new database

4. New form student, enter the name and attribute of the column

4, add content (Increase), and view (check)

5. View by condition

6, there is a message repeated input, to delete (deleted), modify the Trixiao score (change)

Database Development Foundation-SQL Server Control database service + database creation and management (add and revise)