How to open SQL2008, how to open SQL

Once the installation is complete, start --- Microsoft SQL Server 2008 --- SQL Server Management Studio

But your SQL Server service must be started, for example, start --- Microsoft SQL Server 2008 --- configuration tool - SQL Server Configuration Manager

The SQL Server service and agent service in must be started.

1. After installing SQL Server 2008, open Microsoft SQL Server Management Studio in the start menu, connect to the server, where the server name is the computer name, enter the user name and password to connect.

2. Right-click the database, click New to create a new database, after entering, enter the database name, click OK to create a new database.

3. Open the test data library, right-click on the table with calendar, and select New Table.

4. Enter the sum of the name, type and length of each field, click Save, enter the table name, and click OK.

5. Mouse right cover button table1 table, select the first 200 rows, you can add content to the table, if you want to modify the table field content, you can right-click the table, select design.

6. If you want to execute SQL statements, click New Query, you can write SQL statements, click Execute, and SQL will be executed.

It's not impossible to open the table:

Click Tools --Options --SQL Server Object Explorer --Commands--Change the value of the Forward command under the Table Box View option to 0

Now right-click on the table you want - All Rows to open the table.

You create a table first, if you create it, when you see that table, click on the table, and then right-click, the first 200 rows, and then you can see the result. Or when you create a new query, you can enter the query statement and execute it.

You attach the database to SQL Server 2008, click on the database you have attached, find the table you want to open, and right-click on it.

Right-click and have a selection to view 1000 to see.

If you want to display them all, then you need to remove the 1000 limit in the statement.

You send an email, I'll send you a software, which is the graphical management interface of SQL Server.

It can only be the kind of query, you have to look at all of them, and remove the limit of 1000 in the statement.

Please, it's said that 2008 management studio is like this, to be direct only the first two hundred lines, or query.

1.The easiest to see is this help document.

2.The most commonly used basic Open SQL Server Management Studio

1. On the Start menu, point to All Programs, point to Microsoft SQL Server 2014, and then click SQL Server Management Studio.

2. In the "Connect to Server" dialog box, check the default settings, and then click "Connect". To connect, the Server Name box must contain the name of the computer on which SQL Server is installed. If the database engine is a named instance, the Server Name box should also contain the instance name in the format Computer Name Instance Name.

3. View multiple query windows.

In the main toolbar, click Database Engine Queries. In the Connect to Database Engine dialog box, click Connect.

In Object Explorer, right-click the server, and then click New Query. In this case, the querier will use the connection information of the registered server.

Notice how each window appears as a tabbed window on the right side of Object Explorer.

3.Or a tutorial.