2
, 2011
377:681.3.06: 519.682.5
. : 2011. 57 .
: ... .. , . . ..
"___"_____________ 2011 . ______
________________ ..
"___"_____________ 2011 . ________.
__________________
-
, 2011
" "
SQL Server Management Studio MS SQL Server 2008.
, .
, , .
( ), . .
(), . - . ( ), .
.
.
education3
Student ("") | |
Student_id | |
Family | |
Name | |
Last_name | |
Course | , |
Stipendia | |
Birthday | |
Inst_id | (), |
Kod_sp | |
Room_camp |
Parents ("") | |
Student_id | |
Town_id | |
Kod_school | |
Number_school | |
Medal | |
Street | |
House | |
Flat |
Medali ("") | |
Medal | |
Name_medal |
Town ("") | |
Town_id | |
Town_name |
|
|
Uch_plan (" ") | |
Kod_sp | |
Subj_id | |
Sem_r | |
Hour | |
Attest |
Spec ("") | |
Kod_sp | |
Name_spec |
Lecturer ("") | |
Lect_id | |
Family | |
Name | |
Last_name | |
Inst_id | (), |
Subject (" ") | |
Subj_id | |
Subj_name |
Institute ("/") | |
Inst_id | () |
Inst_name | () |
Rating | () |
Subj_Lect (" ") | |
Lect_id | |
Subj_id |
Exam ("") | |
Exam_id | |
Student_id | |
Subj_id | |
Mark | |
Exam_date | |
Lect_id | |
Sem_r |
1
.
:
1) ( , ):
.. | -102 | 12.12.98 | .. | ||
.. | -102 | 16.12.98 | .. | ||
.. | -102 | 20.12.98 | .. | ||
.. | -101 | 12.12.98 | .. | ||
.. | -104 | 16.12.98 | .. | ||
.. | -104 | 20.12.98 | .. | ||
.. | -101 | 16.12.98 | .. | ||
.. | -102 | 12.10.99 | .. | ||
.. | -104 | 12.10.99 | .. |
:
, , ( ), ,
,
,
, ,
/ ,
,
, .
2) :
- () ,
- _,
- ,
- ,
- ,
- _,
- ,
- ,
- __,
- _,
- _ (3-5 ),
- __,
- __,
- __,
- _,
- ___,
- __,
- .
3) 8 . , :
- () ,
|
|
- 5 ( - ),
- . , , . , , ,
- 10- .
4) , :
- - ( , .. ),
- , ( ),
- , ( ). ,
- , , , ( ), .
.
5) (), , , , .
6) , .
7) , .
!
.
8) ( , ).
9) , ( [1]), .
10) ( . 1 . 9). . , , .
11) , , , . .
12) , , , .
1. ?
2. .
3. ?
4. ? ?
5. , ?
2
1) () :
( R1):
( R2):
2) , :
(R3=R1ÈR2),
(R3=R1ÇR2),
(R3=R1\R2).
3) ( R3)
|
|
4) () (R4=R2ÄR3).
5) :
- (), , 3000,
- (), , 2300 3300, ,
- , .
6) ,
:
1. : R=R[ ].
, AND, OR, NOT. .
2. : R1=R1[ ].
, .
7) :
‑ ( , ) ( , , ),
‑ 5- .
‑ .
‑ . .
:
R=R1[ ] R2
‑ (, , ). , ).
‑ .
‑ (. ) ( ) () , , .
8) :
:
- R7=(, , ),
- R8=(, ),
- R9=(, ).
R8-R9 () , R7 - 20 .
:
- , ( ).
- , (. . R9).
- , ( ) ( ).
- , .
- | | ( ).
- , 3 5 (, R7 R8).
! :
.
:
- ,
- ( ),
- .
3
SQL SERVER MANAGMENT STUDIO (SSMS)
: SSMS.
:
1. .
2. .
|
|
3. SSMS.
SQL Server Management Studio (SSMS) , , Microsoft SQL Server. - , .
SSMS Object Explorer, , .
1. :
, - Microsoft SQL Server 2008 SSMS.
. , , SQL Server. Database Engine , < _ >\< _ >.
SSMS . , , Management Studio.
2. :
, . .
. .
. .
, .
, .
Management Studio .
3. :
. , .
. , . , , . . , . .
4. Management Studio.
:
o
o ()
o
o
o
.
, .
, .
Management Studio. , , Management Studio.
Management Studio. .
.
, .
, .
, .
5. .
SSMS , Management Studio . Management Studio .
.
. .
o . .
o . , Query Analyzer SQL Server 2000.
o .
|
|
o .
.
, .
6. SSMS:
SSMS , , SSMS. SSMS.
: , ( ).
:
o .
o , .
o .
o .
o .
7. SSMS (> | Ctrl+Alt+F5). , .
:
1. SQL Server Management Studio?
2. SSMS?
3. ? ?
4. . .
5. ?
6. ?
7. SSMS?
8. .
9. ?
10. , : , , .
11. , : , , .
12. SSMS, MDI : , , .
13. SSMS ?
: , SSMS.
4
SQL SERVER MANAGMENT STUDIO (SSMS)
: SSMS.
:
1. SSMS;
2. SSMS;
3. .
:
1. SSMS ( | Be | Microsoft SQL Server 2008 | SQL Server Management Studio).
2. Options (), Connect to Server ( ). .
a. Server type ( ).
b. Server name ( ). SQL Server, Connect to Server ( ). Server name, <Browse for more...> (< ...>).
c. Authentication ( ). .
3. Options (), Connection Properties ( ). .
a. Connect to database ( ). , , Login () . -, , . , Windows (login) SQL Server. , .
b. Network (). , SQL Server. .
c. Connection (). - . , Connection time-out ( ), , . 15 . , , WAN SQL Server - (ISP, Internet Service Provider). , Execution time-out ( ), - T-SQL. -; , .