A two-dimensional table in a database-skillfully borrowing Excel

the difference between a one-dimensional table and a two-dimensional table a one-dimensional table is also often called a pipelining table, and the biggest difference between a PivotTable report made with a two-dimensional table is the row total. One of the simplest ways to judge whether a data is a one-dimensional table or a two-dimensional table is to look at the contents of its columns-each column is a separate parameter. If each column is a separate parameter that is a one-dimensional table, if each column is of the same type, then it is a two-dimensional table.


establishment of two-dimensional table

started on the internet has been looking at how to build a two-dimensional table in the database, check a lot of information is mostly static and dynamic SQL statement building, look at it is not very clear but when the query always come out of Excel how, So I would like to be able to write in Excel and then import into the database, a search for information, if possible, now summarized as follows:

1) Create an Excel table to build the format you want,

2) Create a database, and then import the Excel table, in the following steps:

2.1> find a new database right-click the task double-click Import data

2.2> the Microsoft Excel option from the drop-down list box of the data source, authentication chooses the way you log in, using the SQL Server province authentication

2.3> Select the edited file, next

2.4> in accordance with the provisions, the server name here to write their own instead of the local

2.5> Select the first one

2.6> Follow the instructions in the diagram and continue to the next step until the final completion.

3) finally

A two-dimensional table in a database-skillfully borrowing Excel