( ). |
- . . .
- , -. ( - ).
, .. , , , , .
, ( , , ..). , () , .
-.
, : ; ; ; , .
2) SELECT SQL. UNION. EXIST NOT EXIST.
SELECT columns FROM tablesWHERE EXISTS (subquery);
, subquery , .. - , FROM , WHERE .: :
SELECT FROM WHERE EXISTS (SELECT FROM
WHERE .=.)
EXISTS NOT EXISTS . TRUE FALSE. EXISTS TRUE , . , EXISTS FALSE. NOT EXISTS , EXISTS. EXISTS NOT EXISTS , .
SELECT FROM WHERE NOT EXISTS (SELECT FROM
WHERE .=.)
UNION [SQL Statement 1] UNION [SQL Statement 2]
SELECT Date FROM Store_Information UNION SELECT Date FROM Internet_Sales;
: Date Jan-05-1999 Jan-07-1999 Jan-08-1999 Jan-10-1999 Jan-11-1999 Jan-12-1999
SELECT Date FROM Store_Information
UNION ALL
SELECT Date FROM Internet_Sales
3) , .
. , .. , .
. , , , .. , , .
:
· - . . 1 A. 1 2 A. 2 ROLLBACK (, ). A 1 , . . , . 1 , 1 A. .
· - " ". 1 2. 1 A. 2 A. , 2 "" ( , 1 ). ( ). "" , 1, A, A ( A 1).
· - . . 1 A. 1 2 A COMMIT. 1 A . , 1 A. , , , .
, , ( , SQL 2). , . , (, , ). .
MS SQL Server 2000:
, Read Committed, . , , , Read Uncommited.
Read Uncommited, , . , , , , .
Read Committed, . , , .
Repeatable Read, , , . , , , , , .
Serializable Repeatable Read . .
" ":
1 - . .
2 -
...
31 - . ,
32 - : IBM DB2, ORACLE, MS SQL Server, Informix. .
33 - ( ).
34 - . .
35 - . LOCK TABLE.
...
43 - .
44 - - . .
45 - .
: |