6. , SQL Server.
7. ? .
8. , :
a. ,
b. ,
c. .
9. VARCHAR CHAR?
10. NVARCHAR VARCHAR?
11. INT?
12. .
8
IN, BETWEEN, LIKE, IS NULL
1) , IN / BETWEEN. :
- ( (, !) ). , , ( IN);
- , ( IN). ;
- , ( IN);
- , /. , /. / ( IN BETWEEN);
- , ( BETWEEN);
- , ( BETWEEN);
- , . MONTH(date), ( IN, BETWEEN);
- , (, 400 600 .).
2) , LIKE. :
- , ;
- , , ;
- , ;
- , ( 3-4 );
- , - ;
- , - ;
- , , , ,
- , ( ),
3) , student (NULL). NULL and or.
|
|
4) . .
1. IN.
2. BETWEEN.
3. LIKE .
4. -, LIKE, .
5. MONTH, .
6. NULL.
7. binary()?
8. ESCAPE LIKE?
9
1). (. ).
2) SIN, FLOOR, CEILING, EXP, SQRT, ROUND, MOD, LN, LOG10.
, ( ), , . , . . .
FLOOR, CEILING, ROUND, MOD - . (. )
{Fn floor(<>)}
, , , .
3) + CONCAT, CHARINDEX, LEFT, REPLACE, (LTRIM) (RTRIM) , SPACE, SUBSTRING.
- , , ( , ):
- LEFT,
- + LEFT,
- ,
- () ,
- (###########################), ( lecturer), LPAD, RPAD, LEN. 6‑ . ,
- (1-4 ) subj_name ,
- ( subject).
4) SYSDATETIME, GETDATE ( SELECT), DATEADD, DATENAME , MONTH, DAY, YEAR, (, ). -.
|
|
5) DATEDIFF ( student). ( , , , ) .
1. ('', '', '') CONCAT.
2. .
3. CHARINDEX?
4. , , ?
5. SYSDATETIME GETDATE?
6. ( ).
7. .
8. n- R? R .
9. DATEADD? .
10. SPACE.
11. DATEDIFF .
12. DATEPART?
10
SQL SERVER.
(COUNT(), MIN(), MAX(), SUM(), AVG())
1) student.
2) , .
3) student, NULL.
4) (COUNT()) student ( family, stipendia, room_camp) c ( , ).
5) , MIN (MAX AVG) - ( ).
- ( student) , ;
- , ;
- , ;
- .
6) .
7) 5 ( ) , , .
8) (GROUP BY ), . . , :
) ,
) ,
) .
9) - . . .
10) . 8. .
11) , . .
12) , , , .
13) , . .
14) , . : .
|
|
15) .
16) . .
17) ( student).
18) .
19) ( ) .
20) - .
1. ?
2. COUNT() , (*) ?
3. ?
4. GROUP BY.
5. , GROUP BY.
6. HAVING?
7. , WHERE HAVING?
8. , ?
9. GROUP BY HAVING .
10. .
11
. (DROP, CREATE, DELETE, INSERT)
!
/ .
1) (DROP CREATE) (DATABASE), (TABLE), (INDEX), (DEFAULT), (PROCEDURE), (FUNCTION), (ROLE), (SCHEMA).
2) Transact-SQL c 11-12. (, ‑406__11-12).
3) , . . .
4) DROP DATABASE .
5) CREATE TABLE. .
6) :
a) , MSSQL (. 2),
b) (DELETE, INSERT).
7) Transact-SQL:
avto (CREATE TABLE):
o ,
o ,
o ,
o ,
o ,
5 (INSERT). , , ,
avto. (DELETE, TOP),
( PERCENT),
avto.
8) Transact-SQL:
tovar :
o ,
o ,
o ,
o ,
o ,
o ,
o ,
o ,
:
o , ,
o ( ),
|
|
o ( ) NULL,
tovar 8 ,
. : , / ,
, NULL.
9) SSMS \ . , (database), (table), (view), (index), (function), (trigger) ..
10) hospital. , , .
11) pacient :
o ,
o ,
o ,
o ,
o ( ),
o ,
o ,
o .
12) doctor :
o ,
o ,
o ,
o .
13) palata :
o ,
o ,
o ,
o ,
o (, ).
14) Transact-SQL (INSERT);
- (10 5-6 ),
- (3-5 ).
15) , (NULL) (NOT NULL) , - .
16) T-SQL hospital ( !!!) , :
o ,
o , , ,
o , ( ) ( ) . , , , , ,
o ,
o , , , , ,
o ,
o ,
o ,
o , (, ).
9) .
1. ?
2. MDF? NDF?
3. ?
4. ? ?
5. ?
6. ?
7. ()?
8. . .
9. . , .
10. ORDER BY . .
11. COUNT() NULL, :
a. , , (.. COUNT( ));
b. COUNT() .
12. .
13. SELECT .
12
. (INSERT, UPDATE)
!
, , .
1) tovar INSERT;
- (5 ),
- (3-5 ),
- , , (2‑3 ).
|
|
2) ( ), .
3) tovar INSERT 8 .
4) 5 DELETE ( ).
5) .
6) Tovar ( CREATE INDEX):
- (, - );
- (, ).
7) DELETE.
8) , , 500.
9) .
10) 10 , 100 200, 200 300 ( ).
11) , WHERE - .
12) tovar1 , tovar ( SELECT INTO).
! SELECT INTO , , (. 3).
13) , tovar1 tovar, (SELECT ). 2 , .
14) tovar2, tovar , WHERE.
15) UPDATE. SQL update, F1.
16) tovar2 (- ) UPDATE:
,
, ,
, WHERE ,
+=, ‑= .
17) .
1. CREATE INDEX.
2. ?
3. CREATE ? ?
4. SELECT INTO?
5. UPDATE?
6. , ? , .
7. ? ?
8. ?
9. ?
10. ?
11. ? ?
12. UPDATE?
13. SET UPDATE.
14. ( T-SQL)?
15. ?
16. ?
17. INSERT.
18)
13
. . (NOT NULL, DEFAULT, UNIQUE, CHECK, ALTER TABLE)
1) hospital 5 diagnoz, (. ) . :
,
,
,
,
,
,
.
2)
COUNT(*),
COUNT( ), ,
COUNT( ), .
3) , , 15% 0,5 (UPDATE).
4) worker 10 , (DEFAULT) ( ). :
, ,
, .., (3 ) ,
, ,
,
,
,
.
!
INSERT , DEFAULT.
4) worker ( worker1) 5 , ( ) . , .
5) worker1, :
18 ,
( ),
() ( ).
18 60 18 55 .
, . .
!
, (CHECK), (,
CHECK (pol='' OR pol=''))
CHECK (pol IN('','')).
.
. :
CHECK ((dolgn='' AND pol='') OR (pol='') OR (pol=''))
6) .
1. ? .
2. ? ?
3. ?
4. ?
5. ?
6. CHECK?
7. ? ?
8. .
9. UNIQUE? PRIMARY KEY? FOREIGN KEY?
10. NULL DEFAULT.
11. ?
12.
14
. (ALTER TABLE, ADD, DROP)
!
.
1. Transact-SQL c 14. (, ‑406__14).
2. car :
,
,
,
,
,
;
3. car ALTER, :
( ADD), NULL ,