Karpova_bazy_dannyh

243

, . ,

1 , R1,

, 2, -

,

.

, -

.

,

, -

.

,

). S (-

) X (). -

: S X

IS, IX SIX.

IS (Inteated for Shared lock, ) 0 - 0 . ,

244 11.

.

2.-, -

I-6,

.

X

SIX

IS

. 11.12.

-

, , (, ,

S ).

, , -

.

, .

, . , :

- {} .

.

S-X, X-S, -, -

.

, ,

1 (1<=<=4) (b=5), 2 -

(1<=<=3) (1<=b<=3), . : (n= 2).

, , -

.

4

3

2

(1<=a<=5) & (1<=b<=3)

1

a

. 11.13.

().

t 1

:

.

12 SQL

SQL :

-

.

-

, -

.

SQL ,

249

SQL 5 (.

. 12.1).

Select F, J, K

FROM A, B

WHERE A.F=B.F

AND J>400

AND K=10g

1

SQL

2

SQL

3

SQL

4

SQL

SQL

5

. 12.1. SQL

1. SQL.

SQL-pa

.

. .

3. .

-

.

.

SQL

SQL -

:

SQL -

. SQL, SQL.

SQL -

.

SQL SQL--

.

(NULL) -

.

SQL , SQL.

SQL. (SELECT) .

SQL 2 :

, -

. .

SQL, :

SELECT [{ALL | DISTINCT}] <>

INTO < >

FROM <>

[WHERE < >]

(

R E A D E R _ 1 D S m a l l i n t ( 4 ) P R I M A R Y K A Y , FIRST_NAME char (30) NOT NULL,

LASTJIAME char (30) NOT NULL, ADRES char (50), HOME_PH0N char (12),

WORK_PHQN char (12),

BIRTH_DAY date CK (Date Diff (year. Get Date (), BIRTH_DAY) >=17)

DECLARE @READER_ID int

DECLARE @FIRS_NAME char (). © LAST_NAME char (30). @DR5 Char (50)

DECLARE ®HOME_PHON hr (12). @WORK_0 Char (12)

/* */

SET @READER_1D = 4

/*

*/

SELECT READERS, FIRST_NAME. READERS LAST_NAME. READERS.ADRES,

READERS HOME_PHON, READERS WORK_PHON

INTO @FIRS_NAME. @LAST_NAME. @ADRES. @HOME_PHON. @WORK_PHON.

FROM READERS

WHERE READERS READER_ID = @READER_1D

,

READERS, .

, Transact SQL -

@. , -

, , .

,

.

. ® READER_ID . 4, , - WHERE.

,

, READERS, .

,

.

. SQL.

FETCH , -