( ADD), NULL ,
(DROP) ( ),
() ( ALTER),
( ADD) UNIQUE,
( ADD) DEFAULT. ,
- ( ADD),
, NULL, (ADD),
(, UNIQUE) ( DROP),
(ADD):
,
o ,
o ,
o , , ,
,
. .
4. . .
1. ALTER TABLE?
2. ALTER TABLE. .
3. ?
4. ?
5. ALTER TABLE UPDATE?
6. ADD? ?
7. ADD.
8. ? ?
9. ?
10. ?
11. , ?
. . USER, DB, HOST, TABLES_PRIV, COLUMNS_PRIV, . ( GRANT)
, , ( ). , , . . .
1) USER, DB, HOST, TABLES_PRIV, COLUMNS_PRIV MySQL. Priveleg sql ( 4). .
2) (SHOW GRANTS) .
3) dostup_r ( , , , ). , , ( ).
4) SELECT, INSERT.
|
|
5) , (SHOW GRANTS).
6) dostup_r , . .
7) dostup_r . .
8) dostup_r.
9) dostup_l ( , , , ). , , ( ).
10) ( ) SELECT, INSERT.
11) , (SHOW GRANTS).
12) dostup_l , . .
13) dostup_l . .
14) dostup_l.
1. . ‑ : 2002. 21 .
2. . MySQL. . . . .: "", 2002. 624 .; .
3. . MySQL: ‑ .: "", 2001.‑ 816 .: .
4. .. SQL : . / .. , .. , .. . .: , 2002. 176 .
1
SQL MSSQL
MSSQL. . .
CEILING(x) ‑ , ( ).
STR1+STR2+ ‑ , .
GETDATE(), SYSDATETIME() .
DAY(date) ‑ .
MONTH(date) ‑ .
YEAR(date) ‑ .
DATEADD(datepart, number, date) ‑ number datepart date ( datepart YEAR, QUARTER, MONTH, WEEK, DAY, HOUR, MINUTE, SECOND, MILLISECOND).
DATENAME(datepart, date) ‑ ( ) (, , , , ,..) date.
EXP(x) ‑ (ex).
FLOOR(x) ‑ , ( ).
CHARINDEX(str1, str2 [, pos]) ‑ str1 str2, pos str2.
LEFT(str, len)/RIGHT(str, len) ‑ len / str.
LEN(str) str.
LOG(x) ‑ .
|
|
LOG10(x) ‑ .
LTRIM(str) ‑ .
RTRIM(str) .
X%Y ‑ .
REPLACE(str, str1, str2) ‑ str str1 str2.
ROUND(x[,d]) ‑ , d . d , d>0 d , d<0.
SIN(x) ‑ . .
SPACE(n) ‑ n .
SQRT(x) ‑ .
2
SQL Server
, SQL Server. SQL Server Management Studio, Query Editor ( ). SQL Server Management Studio. Student . , .
SQL Server , . , .
, , . , "n" Unicode. Unicode, SQL Server, , - . 00 , . .
, . , .
Char
char . 20 , 20 . , , . , char (10), "" " ". , , , .
Nchar
nchar char, Unicode, ANSI. Unicode , ANSI. ANSI 256 , Unicode 65 536 . Unicode SQL Server ; SQL Server , ANSI.
Varchar
varchar - , char. , . , varchar(50), 50 . 3 , 3 . , , , . varchar 8000 . . (. . varchar ()), 1.
|
|
, 8000 , max. , 8000 , , . , 8000 , , , * . , max , . . , , text.
Nvarchar
nvarchar varchar, - Unicode .
Text
text 8000 . .
Ntext
ntext Unicode- text .
Image
image text, , , , , . .
Int
int integer ( ). : int -2 147 483 648 2 147 483 647.
Bigint
bigint big integer int,
-9 223 372 036 854 775 808 9 223 372 036 854 775 807.
Small int
smailint small integer -32 768 32 767. , , . , , int.
Tiny int
tinyint tiny integer , smallint, 0 255.
Decimal/numeric
, decimal numeric, . -1038 + 1 10" - 1. : -0.00000000000000000000000000000000000001
10 000 000 000 000 000 000 000 000 000. , 38 . 38 . , , .
Float
float . float -1.79x10308 1.79x10308. : 100%, . . . - . , .3,.6 .7. , . . - , , . .
|
|
Real
real float, , real -.401038 3.40x1038. .
Money
money . , , , decimal. , , , . money -922 337 203 685 477.5808 922 337 203 685 477.5807. ($ USD , £ GBP . .), , . . money . , money, 1/10000 ( ) , , .
Smallmoney
money : -214 748.3648 214 748.3647.
Date
date 1 1 . . . 31 9999 . YYYY-MM-DD. SQL Server NET. , . , . . , , datetime.
Datetime
datetime 1 1753 . 31 9999 . , YYYY-MM-DD hh:mm:ss. , datetime, , 12:00:00.
Datetime2
datetime datetime2 . , datetime2 . 1 1 . .. 31 9999. YYYY-MM-DD hh:mm:ss[.nnnnnnn].
Smalldatetime
smalldatetime datetime, : 1 1900 . 6 2079 . , , .
Datetimeoffset
, datetimeoffset. UTC (Coordinated Universal Time, ), , , . , 6 24 2008 . 2008-03-24 13:00:00'+05:00, . . - UTC. : YYYY-MM-DD hh:mm:ss[.nnnnnnn] [+|-]hh:mm.
Time
24- , time : hh:mm:ss[.nnnnnnn]. time , date, . , time 100 , , , datetime.
Hierarchyid
SQL Server 2008 , , (self-join). hierarchyid, , . CLR (Common Language Runtime, ), .
Geometry
geometry CLR, " ". 11 , , . , .
|
|
Geography
geography CLR " ". , , geometry.
Rowversion
rowversion , . . , . rowversion SQL Server , . . , , . rowversion timestamp, , , timestamp , SQL Server.
Uniqueiden tifier
uniqueidentifier (GUID, Globally Unique Identifier). timestamp , SQL Server . , , . , uniqueidentifier . .
Binary
binary . . , , , . , ( I), ( 2), 1000 $ ( 4) ( 8), . 13 1 + 4 + 8 , , 1000 $, . .
Varbinary
varbinary binary , . varbinary (max) 8000 , , .
Bit
bit 0 I. , bit true (I) false (0).
Xml
XML , varchar (). . SQL Server 2005 XML - , SQL Server XML.
, . .
Cursor
, cursor, . , . . , . , . .
Table
table , . , . 3 , . cursor table , . . .
Sql_variant
, . , .. , , , . , , , . , sql_variant , , . .
, , SQL Server ( , , ), . .
IDENTITY
SQL Server , , . ApressFinancial , . , (, ). , , . Customers 100 Transaction , , 100. , T-SQL , " ". , identity.
identity SQL Server , :
, SQL Server;
( );
, SQL Server , ;
SQL Server.
, ; SQL Server . set identity_insert on .
SQL Server , . , , .
3
MS SQL?
:
SELECT * INTO table_copy FROM original
table_copy , original , . WHERE, , .
, 2 :