SQL server
_________________________
SQL server,
2 , , , , , , ...
Databases -
,
SQL server
Access SQL server
Tools,DataTransfomation Servises, import Data
(Sourse) Driver do Microsoft Access [*.mdb] .. , , . , . New, , Driver do Microsoft Access [*.mdb], , First_A, . .mdb, . , Local , . . , , , , . . Refresh ()
SQL server Access
Access 2 (, , ). , , . SQL server, . . 37 . . . . , SQL server. (Local), , , . Access - .ADP. SQL server , . . , ,
SQL server
1 Enterprise Manager
2
3 dadabases ; All Tasks ( ); Attach Dadabase ( )
4 (*.mdf)
5
Transact-SQL
Query Analyser
Transact-Sql . .
|
|
, Query-Analyser, .
Celect * from bd
Go
Select * from i1
Save , .
Object Browser
-
- (Views)/. , .
- ( )
- ( Columns )
- ( ) ( )
.
Create , , , , , |
Drop () |
Alter () , |
Select , |
Insert |
Update |
Delete |
Execute , |
,
Select?
?
?
Enterprise Men.
Server Group
Server EnterpMen
Database .
Dada Transformation , ,
Services
Management SQL Server
Replication
Security SQL Server
Support Services
Meta Data Services ( )
Master SQL Server,
. Master
.
Model . ,
.
Msbd SQL Server Agent
(, ).
Tempbd
Diagram
Table
View
Stored Procedure Transact SQL, .
User SQL Server
Role
Rule
Default , SQL Server, .
User Defined Data Type , .
User Defined Function Transact SQL
.
: (WorkMS),
(),
(dbo),
(bd.f)
: WorkMS..dbo.bd.f
(