How to use SQL server for the first time-writing to a newbie and SQL server to a newbie

How to use SQL server for the first time-writing to a newbie and SQL server to a newbie

1. Put the DATA table given by the instructor in the directory [C: \ Program Files \ Microsoft SQL Server \ MSSQL10_50.MSSQLSERVER \ MSSQL \ DATA.

2. enable SQL server 2008. Link to the local server.

If the connection fails

The SQL server service has not been started yet. Click Start> Control Panel> Administrative Tools> services to start the SQL server service.

Then you can open the SQL server link to connect to the server.

3. After opening, right-click the database option in object Resource Manager and select additional ].

Next, open the "Attach Database" Page, select "add", and select the file that you just placed in the database. Here I am [school_Data ].

Click OK, and then click OK. The database is successfully added.

4. Click Create query and enter the SQL statement,

SELECT * FROM STUDENTS

You can see the content in your table!