SQL Server Getting Started review (2008) diagram

1 First find the relevant content in the Start menu, such as; The installed components may vary; My computer includes the following items;

Business intelligence; management console; Import and export data; Analysis Services; Integration services; configuration tools; documentation and tutorials; performance tools;

Because there are many components of an even load;

2 Entering the management console

The first is login; server type select the database engine; Login with Windows authentication first;

3 Entering the management console

The interface is as follows; see four subkeys under the database, system database, database snapshot, ReportServer, reportservertempdb; because I installed the Microsoft Report Server, so there are reportserver;

The first-level entries in the tree view on the left are: database, security, server object, replication, management, SQL Server Agent;

4 Right-click on the database, pop up the following menu;

Includes the following submenu: New database, attach, restore database, restore files and filegroups, start PowerShell, report, refresh;

5 Select New Database

Enter the database name; The database of the management information system for transmission is established here, the name is Shudiansuo;

You can set the path to the database files and log files;

The database file belongs to the primary filegroup by default, and the initial size of both files is 3 and 1MB by default.

6 Click the View connection properties at the bottom left, and you can see the current connection properties;

Attributes are divided into four groups: product; server environment; connection; authentication;

7 Right click on "table", pop up as follows;

Includes five items: new table; filter; start PowerShell; report; refresh;

8 and 9

Enter the column name and data type in the popup interface;

Right-click at the beginning of the line, pop up below;

Include: Set primary key, insert column, delete column; relation; index/key; full-text index; XML index; CHECK constraint; spatial index; Generate change script;

Select the first item, set the first column as the primary key;

Description of the field type:

Char: fixed length, storing ANSI characters, insufficient complement English half-width space.
NCHAR: fixed length, storing Unicode characters, insufficient complement to English half-width space
VARCHAR: variable length, storing ANSI characters, automatically changing according to data length.
NVARCHAR: variable length, storing Unicode characters, automatically changing according to data length.

bigint
Integer data from -2^63 (-9223372036854775808) to 2^63-1 (9223372036854775807)
(all numbers). The storage size is 8 bytes.
Int
Integer data (all numbers) from -2^31 (-2,147,483,648) to 2^31-1 (2,147,483,647).
The storage size is 4 bytes. The SQL-92 synonymous word for int is integer.
smallint
Integer data from -2^15 (-32,768) to 2^15-1 (32,767). The storage size is 2 bytes.
tinyint
Integer data from 0 to 255. The storage size is 1 bytes.

Because the voltage level does not exceed 255, so its ID takes tinyint type;

10 Right click in the position, popup as menu;

Include the following submenu items: Save, close, all but close, copy the full path, open the folder;

11 Select Save, enter table name;

12 Right-click on the name of the new table and pop up the following menu;

Include submenu: New table, design, select first 1000 lines, edit first 200 lines, write table script for, view dependencies, full-text index, storage, strategy, aspect, start PowerShell, report;

13 Select Edit the first 200 lines, start data entry;

14 Click New Query on the tool bar;

15 in the New Query window, enter the following SQL statement, click Execute;

The input data is queried, such as;

Note: On the top left, in the toolbar drop-down list, to select the database you want to manipulate, here is Shudiansuo;

SQL Server Getting Started review (2008) diagram