5.19. :
INSERT INTO Employee (id, name) VALUES (4, "");
5.20. , ( TmpTable Employee, , 2):
INSERT INTO TmpTable (id, name)
SELECT id, name FROM Employee WHERE Employee.id>2;
() UPDATE.
UPDATE SET
1 = 1,
2 = 2,
WHERE C
5.21. Employee:
UPDATE Employee
SET name = ""
WHERE Employee.id = 1;
DELETE,
DELETE FROM WHERE C
5.22. :
DELETE FROM Employee
WHERE Employee.id = 1;
5.23. :
DELETE FROM Employee.
5.7. : ,
- , , . . , , , .
, . (//), , .
, :
, , . , , primary key.
, ;
, - .
, . , . . , .
Microsoft SQL Server : .
. , , : . , , , .
. ( , ).
, , SP_HELP _. - CREATE INDEX/DROP INDEX.