Типы хранимых процедур System stored procedures User-defined stored procedures Temporary stored procedures. - презентация

1

2 Типы хранимых процедур System stored procedures User-defined stored procedures Temporary stored procedures

3 Создание и удаление хранимой процедуры CREATE PROCEDURE ИмяПроцедуры [( [, …])] [RETURNS ( [, ( …])] AS [ ] BEGIN ; [ ;…] END

4 Объявление переменной DECLARE VARIABLE ;

5 Условный оператор IF ( ) THEN [ELSE ] Оператор FOR FOR SELECT INTO DO

6 Операторы WHILE и EXIT WHILE ( ) DO Оператор EXECUTE PROCEDURE EXECUTE PROCEDURE [ [, …]] [RETURING_VALUES: [,: …]];

7 Пример CREATE PROCEDURE (Nakl INT) RETURNS (Name VARCHAR(150), Quan SMALLINT, Price FLOAT, Summa FLOAT) AS DECLARE VARIABLE Aut VARCHAR(40); DECLARE VARIABLE Pub VARCHAR(40); BEGIN FOR SELECT BName, BAuthor, BPublish, MQuan, MPrice, MQuan*MPrice FROM Books, MoveBook WHERE MNakl:=Nakl AND BookID=MBook ORDER BY BName INTO :Name, :Aut, :Pub, :Quan, :Price, :Summa DO BEGIN Name:=Name || / || Aut || / || Pub; SUSPEND; END

8 Хранимые процедуры в Visual Basic.Net

9