. |
2) . XML .
- , , . . . . , ( ) e () / . (, / , ) (). () , . - , . HTML, DHMTL - CSS - , XML - , XSL - DOM - XML - , HTML. ,
(XML) “XML – , , ” ISO SGML WWW XML HTML HTML XML XML HTML HTML – , XML – , HTML – XML , XML
XML (. eXtensible Markup Language — ; [--́]) — , . XML — , ( ), , (, XHTML), . XML SGML.
XML , . , XML (, RDF, RSS, MathML, XHTML, SVG), , , , . XML (. namespace).
3) SQL ALTER .
— , SQL-, . , , . , SQL, , . . .
CREATE PROCEDURE . , , tempdb. '#' '##'. ## 20 . , 16, @@NESTLEVEL.
; sp_. , - master. , , , , - master.
́ — , , () — INSERT DELETE , UPDATE . — , SQL Server . , . .
CREATE TRIGGER [owner.]trigger_name
ON [owner.]table_name
FOR {INSERT, UPDATE, DELETE}
[WITH ENCRYPTION]
AS sql_statements
, (AFTER) (INSTEAD OF); , (ROLLBACK TRANSACTION); - inserted deleted, ; .
, - INSERTED DELETED. , . @@ROWCOUNT , . ALTER TABLE . ALTER TABLE . . , InterBase . c , , , .
ALTER TRIGGER . - ALTER TRIGGER , , , , CREATE TRIGGER ALTER TRIGGER.
ALTER TRIGGER :
, activation status , when it performs its actions, , fires , fires.
: AS.
. .
SYSDBA.
: CHECK , ALTER TABLE, .
ALTER TRIGGER name
[ACTIVE | INACTIVE]
[{BEFORE | AFTER} {DELETE | INSERT | UPDATE}]
[POSITION number]
[AS <trigger_body>] [terminator]
" ":
1 - . .
2 -
...
41 - (). . .
42 - SELECT FOR XML. RAW, AUTO, EXPLICIT. XMLDATA .
43 - .
44 - - . .
45 - .
: |