SQL Server Database Fundamentals

How the database uses tables when storing data:

• Columns are called fields in the database
• Rows are called records in the database

Data type:

• Character data type: char, varchar, etc.
• Date Time Data: datetime, etc.
• Numeric type: int, float, real
• Currency Data: Money

Create DATABASE: The primary file is. mdf, and there is only one

Log file. ldf;

Secondary data file. NDF, you can have multiple

The database includes the interface, the service two parts

The following is the SQL Server database interface:

Attaching and detaching a database:

Separation:

Locate the database in SQL Server, right--task--detach

Attach: Select database, right--attach--select need to attach--click Add--OK

Backup and restore of databases

Find the database you need to operate in SQL Server, right--task--backup--OK

Below you can choose where to store

Restores

Select the database you want to manipulate, right--task--Restore--database

：

SQL Server Database Fundamentals