Bit_Length(<>) | <> |
Cast(<> As < >) | <>, < > |
Char[acter]_Length(<>) | <> |
Convert(<> using <>) | <>, <> |
Current_Date | |
Current_Time(<>) | <> |
Current_TimeStamp(<>) | <> |
Extract(<> from <>) | <> (Day, Hour ..) <> |
Lower(<>) | <>, |
Octet_Length(<>) | <> |
Position(<1> in <2>) | , <1> <2> |
Substring(<> from for <>) | <>, <> |
Trim(Leading|Trailing|Both <> from <>) | <>, | | <> |
Upper(<>) | <>, |
User |
2) MS SQL Server
SQL Server , :
→ ;
→ ;
→ ;
→ Text Image;
→ ;
→ ;
→ ( ).
.
3) Oracle
→ ;
→ ;
→ ;
→ ;
→ , ;
→ .
CREATE FUNCTION < > ([< > < > [(<>)], ]) RETURNS < > [(<>)] [[NOT]DETERMINISTIC] [CONTAINS SQL|READS SQL DATA|MODIFIES SQL DATA] BEGIN <SQL-> RETURN < > END
[NOT] DETERMINISTIC , . , CURRENT_TIME NOT DETERMINISTIC.
CONTAINS SQL , SQL-, . .
READS SQL DATA , SELECT FETCH.
MODIFIES SQL DATA , INSERT, UPDATE DELETE.
, . , . . , . , - .
ALTER TABLE . , , , , .. :
;
;
- ;
;
;
;
.
ALTER TABLE:
ALTER TABLE<_>
[ALTER COLUMN <_> [SET DEFAULT <>] | [DROP DEFAULT] ]
|[ADD <_>]
|[DROP COLUMN <_> [CASCADE] | [RESRTICT]]
|[ADD [<__>] | [<__>] | [<_>] | [<__>]]
|[DROP CONSTRAINT <_> [CASCATE] | [RESTRICT]]
ALTER TABLE , .
ALTER TABLE CREATE TABLE (, <_> CREATE TABLE).
ALTER TABLE :
;
;
;
, ( , ).
1. .
ALTER TABLE
ADD _ INTEGER NOT NUL DEFAULT YEAR(GETDATE())
, .
2. .
ALTER COLUMN. , :
PRIMARY KEY FOREGIG KEY;
CHECK UNIQUE ( , , .. , var);
.
, , .
ALTER TABLE
ALTER COLUMN _ CHAR(6) NOT NULL
3. .
CHECK, FOREIGN KEY, UNIQUE PRIMARY KEY, , .
ALTER TABLE
DROP COLUMN _
|
|
.
, FOREIGN KEY : , _: DROP TABLE .
|
|
40)+Microsoft SQL Server. .
SQL Server , . , . , .
SQL Server . , , , , SQL Server , . , , , CHECKPOINT, SQL Server. , , (roll back). , , (forward back). , .
, . SQL Server , . , , , , , , , . , .
, .
, . , . , , , , .
:
, , .
- , . DROP DATABASE sp_dbremove. .
, .
, . SQL Server . , ( ). , - .
|
|
FOR LOAD, , dbo use only Ļ. , .