SQL- : . , *.mdf *.ldf - . ' - , .., ( , ).
SQL- :
CREATE DATABASES.
SQL Server Enterprise Manager.
SQL Server Enterprise Manager . , , ' SQL Server Group, SQL-. ϳ , Edit SQL Server Registration properties Action, SQL-.
Server - , ;
Use Windows NT authentication - SQL- ' Windows NT;
Use SQL Server authentication - SQL-. Login Name Password ' SQL-. , ', SQL-, , Always prompt for login and password, SQL- SQL Server Enterprise Manager ' ;
S erver Group - ;
Show system databases and system objects - SQL- (, , ..) . ( SQL-, , ; ). tempdb. , SQL-: , .. , . , ;
Automatically start SQL Server when connecting , SQL- .
|
|
|
, SQL- , ' . ' sa.
Databases SQL-. 䳿 . SQL Server Enterprise Manager - . New Database Action . 䳿 :
Name ' . Database files ' , . ', . , (secondary - *.ndf). Database files ' , . (primary) . , , .
Automatically grow file / . (In megabytes) (By percent).
3 - ij
, , SQL-. Maximum file size . Restrict filegrowth . , Unrestricted filegrowth , ( . 1). Automatically grow file , Initial size Database files.
EDUCATION, ( ). ϳ ' Databases. +, ' , 3.
3 ' SQL-
| ' | |
| Tables | |
| Views | , |
| Stored Procedures | |
| Extended Stored Procedures | |
| ' | |
| Users | , |
| Roles | , |
| Rules | |
| Defaults | |
| User Defined Data Types |
|
|
|
. , . SQL- ' , ' . 4.
4 ,
| db_owner | |
| db_accessadmin | |
| db securityadmin | |
| db_ddladmin | DDL (Data definition language - ), GRANT, REVOKE DENY |
| dbjbackupoperator | |
| db_datareader | - |
| db_datawriter | - |
| db_denydatareader | ' SELECT |
| db_denydatawriter | ' INSERT, UPDATE DELETE |
| Public | public |
5 ,
| sysadmin | - SQL- |
| serveradmin | SQL- |
| setupadmin | ' |
| securityadmin | , , log- |
| processadmin | , SQL- |
| dbcreator | |
| diskadmin | SQL- |
, , Users ' . dbo (Database Owner - ). :
Users;
dbo;
Action Properties.
dbo (.4).
4 - ij dbo
, . SQL- SQL CREATE TABLE, SQL Server Query Analyzer SQL Server Enterprise Manager. .
' Tables, SQL Server Enterprise Manager , . New Table Action, . , .
STUDENTS. STUDENTS, . . Column Name ( SNUM), , Datatype . , SQL-. ϳ Length ( ), Precision ( ) Scale ( ). .
|
|
|
, 
, , . Delete .
5 - ij
- , , DefaultValue . STUDENTS 䳿 . Default Value STIP 17 , . , , , ⳺, 䳿, .
NULL . SQL- . , Allow Nulls , ' . , SNUM. ( SQL Server Enterprise Manager ), , , ' .
Identity - . , , .
, , (, -), Identity. Allow Nulls, . Identity, Identity Seed - Identity Increment (, ,).
EDUCATION, .
4 EDUCATION
| Column name | Datatype | Length | Precision | Scale |
| STUDENTS | ||||
| SNUM | int | |||
| SFAM | char | |||
| SIMA | char | |||
| SOTCH | char | |||
| STIP | small-money | |||
| PREDMET | ||||
| PNUM | smallint | |||
| PNAME | char | |||
| TNUM | int | |||
| HOURS | smallint | |||
| COURS | tinyint | |||
| TEACHERS | ||||
| TNUM | int | |||
| TFAM | char | |||
| TIMA | char | |||
| TOTCH | char | |||
| TDATE | small-datetime |
|
|
|
, , Design Table Action, .
EDUCATION . SQL Server Enterprise Manager 䳿:
;
Open Table / Return all rows Action;
, , Open Table / Return Top Action. , , .
SQL Server Enterprise Manager. , . . , 
, , . Delete .
. , STIP STUDENTS .
6 - ij
Show/Hide SQL Pane 
SQL-. SQL. , Run 
, . / , Show/Hide Results Pane 
. SQL- ' , Verify SQL 
, , . SQL- .
7 - SQL
