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