32757 | |
1 0485 1 5 | |
, | 2 |
1 024 | |
, SQL- | 32 |
ꠠ | ( ) |
| 250 |
SQL Server 2000 .
- Enterprise Manager. Enterprise Manager Databases New Database ( ).
- Create Database Wizard. Enterprise Manager Run a Wizard ( ) .
- Transact-SQL. CREATE DATABASE.
, SQL-DMO.
Transact SQL. , . , eo - Transact-SQL .
, , . ( , ) , , , , .
:
- sysadmin dbcreator, ;
- , , ;
- () .
SQL Server 2000 . , , . Enterprise Manager , SQL Server 2000. Transact-SQL.
Transact-SQL CREATE DATABASE, :
|
|
CREATE DATABASE database_name
[ON | PRIMARY]
[< filespec >]
[ < filegroup >]
[LOG ON (< filespec >)]
[COLLATE collation_name ]
[ FOR LOAD | FOR ATTACH ]
, . . , db_student: create database db_student
, CREATE DATABASE.
- database_name. , . . , ( ). 128 . , , 123 . - , _Log.
- ON. .
- PRIMARY. , . . . , , , <filespec>. , , (primary file group). (default file group), , .
- LOG N. , . LOG ON . , ec , 25 % , 512 . , _Log.
- FOR LOAD. SQL Server ( SQL Server 7.0).
- FOR ATTACH. , (attach) . .
COLLATE collation_name. , , , .
CREATE TABLE. :
CREA TABLE
[ database_name.[owner] | owner.] table_name
({<column_definition>
|column_name AS computed_column_expression
|
|
|< table_constraint >})
[ON {filegroup | DEFAULT }]
[TEXTIMAGE_ON { filegroup | DEFAULT } ]
.
- database_name , . , . , .
- owner , . , . , .
- table_name . . (owner.table_name) . , . 128 . # ##, . , # ##, 115 .
. , tempdb.
# , SQL Server, , .
##. , Drop Table, , .
<column_definition> ( , , , ..).
- column_name . .
- computed_column_expression , . , . . , , , . .
. : _ AS .
<table_constraint> - ( , ; ; , ..)
-ON (filegroup | DEFAULT} , . . DEFAULT , . ON {filegroup | DEFAULT} PRIMARY KEY UNIQUE.
- TEXTIMAGE_ON , text, ntext image . , . , . , TEXTIMAGE_ON .
|
|
. text 231-1 (2 147 483 647) . ntext Unicode 230-1 (1 073 741 823) . image 231-1.
SELECT, :
SELECT select_list
[ INTO new_table ]
FROM table_source
[ WHERE search_condition ]
[ GROUP BY group_by_expression ]
[ HAVING search_condition ]
[ORDER BY order_expression [ ASC | DESC ] ]
SELECT , . . SELECT FROM.
.
select_list , , . Select , . Distinct, All Top .
[ INTO new_table ] .
FROM table_source .
[ WHERE search_condition ] , , .
[ GROUP BY group_by_expression ] .
[ HAVING search_condition ] - -, .
[ORDER BY order_expression [ ASC | DESC ] ] , . Asc Desc .
SELECT . :
- SELECT; - INTO; - FROM; - WHERE; - GROUP BY; - HAVING; - UNION; - ORDER BY; - COMPUTE; - FOR; - OPTION.
.
UNION , .
COMPUTE .
FOR , Db Library, XML ( HTML).
OPTION , .
, . SQL Server 2000 .
- INSERT. INSERT, , . ( ), .
- SELECT INTO. , , .
|
|
- , , . b BULK INSERT.
- (Database API). ADO, OLE DB, ODBC DB-Library.
- Data Transformation Services. , , , , Oracle, Excel, Paradox, Access .
ADO, OLE DB, ODBC DB-Library . . (Data Transformation Services).
, . UPDATE, , . , , , . , . , , . , .
, UPDATE. :
UPDATE
{table_name WITH (<table_hint_limited>)
| view_name
| rowset_function_limited}
SET
{column_name = (expression | DEFAULT | NULL)
| @variable = expression
| @variable = column = expression }
{ [ FROM (<table_source>)]
[ WHERE <search__condition>]}
[ WHERE CURRENT OF
{([ GLOBAL ] cursor_narne) | cursor_variable_name]}
[OPTION (<query_hint>)]
.
- tab1e_name. , .
- [WITH (<table_hint_limited> [...n])]. UPDATE.
- view_name. , .
- rowset_function_limited. OPENQUERY OPENROWSET, . OLE DB , Microsoft SQL Server.
- SET. SET , . UPDATE , . . UPDATE .
- column_name = {expression | DEFAULT | NULL}. , . DEFAULT , . NULL. , , .
@variable = expression. , . . . , , , .
@variable = column = expression. .
FROM {<table_source>}. (), From.
WHERE <search_condition> Where, Update, , Select.
WHERE CURRENT OF. , .
|
|
. , .
([GLOBAL] cursor_name | cursor_variable_name). . Global , .
OPTION (<query_hint> [n]). Option , .
, .
. , . , . , . , . DELETE, . DELETE . :
DELETE (table_name | view_name)
[ WHERE <search_condition>].
, , , , . , . , WHERE, .
DELETE . . DELETE SELECT.
, DELETE SELECT.
3.5.1. Access.
3.5.2. .
3.5.3. ?
3.5.4. Access ?
3.5.5. ?
3.5.6. Access , ?
3.5.7. VBA Access?
3.5.8. .
3.5.9. VBA?
3.5.10. Variant?
3.5.11. VBA.
3.5.12. , , VBA?
3.5.13. VBA?
3.5.14. VBA .
3.5.15. VBA?
3.5.16. ?
3.5.17. MS SQL Server.
3.5.18. CREATE DATABASE, CREATE TABLE, SELECT, INSERT, UPDATE DELETE Transact - SQL
1. . ..,,1991.
2. .. . . ., ,1987.
3. .. . ., , 1989.
4. .., .. . .,,1995.
5. .., .. . . , , 2000.
5. .., ., .. Access 97. ., , 1998.
7. . : , , . . , , 2001.
8. . SQL. . , ,2001.
9. ., . Wicrosoft Office 2000. . , , 2000.
10. ., ., . . ., , 1986.
11. .. VBA 2000 ., , 2000.
12. .. . . , , 1998.
13. .. Access. . , , 2003.
14. Access. . .. , , 2000.
. 3
1. . 3
1.1. . 3
1. 2. . 4
1.2.1. . 5
1.2.2. . 6
1.2.3. . 7
. 7
. 11
1.3. . 12
1.4. . 13
1.5. 17
1.5.1. . 17
1.5.2. , 20
. 20
. 21
. 21
1.5.3. -. 22
. 22
. 24
. 26
. 29
1.5.4. . 31
1.5.5. . 33
. 33
. 34
.. 35
1.6. ER - . 36
1.6.1. . 36
1.6.2. . 39
1.6.3. ER .. 43
1:1 44
1:N. 48
N:M 52
1.6.4. , ER - 53
. 53
58
. 59
1.6.5. ER- 63
1.6.6. 64
1.7. .. 65
1.8. .. 69
2. . 70
2.1. . 70
2.2.1. . 70
2.2.2. . 74
SQL. 77
MS SQL Server 82
2.2. . 91
2.3. 98
2.4. .. 104
2.4.1. . 104
2.4.2. .. 104
2.4.3. . 106
2.4.4. . 108
2.5. , 108
2.5.1. - 108
2.5.2. .. 110
2.6. .. 112
3. 113
3.1. .. 113
3.2. Access. 115
3.2.1. . 115
3.2.2. . 120
3.2.3. . 121
3.2.4. . 140
3.2.5. .. 146
3.2.6. Access. 154
3.2.7. Access. 158
3.2.8. . 171
3.3. Access. 172
3.3.1. . 172
3.3.2. . 181
3.3.3. .. 184
3.3.4. Variant 186
3.3.5. . 188
3.3.5., VBA.. 191
3.3.7. VBA.. 196
3.3.8. VBA.. 202
3.3.9. Access. 209
3.3.10. Access. 214
3.3.11. VBA.. 217
3.4. MS SQL Server 221
3.4.1. SQL-. 221
3.4.2. . 221
3.4.3. .. 224
3.4.4. . 227
3.4.5. . 228
3.4.6. . 229
3.4.7. . 231
3.5. .. 232
. 233
. 234