SQL Server first Use method--for beginners

1. Place the data sheet given by the teacher in the directory "C:\Program Files\Microsoft SQL Server\mssql10_50.mssqlserver\mssql\data".

2. Open SQL Server 2008. Link the local server.

If the connection is not on, the display

Then the SQL Server service has not been started. Click Start-Control Panel-Administrative Tools-Services-Start the SQL Server service.

If you open the SQL Server link again, you will be able to connect successfully.

3. After opening, right-click the database option in the Object Explorer and select Attach.

Then open the "Attach Database" page, select "Add", select the file just put into the database, I am here "school_data".

Click "OK" and click "OK" to successfully add to the database

4. Then click "New Query", enter the SQL statement,

SELECT *from STUDENTS

You can see the contents of your table!

SQL Server first Use method--for beginners