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

Source: Internet
Author: User
Tags mssqlserver

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)

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.