ストアドプロシージャ can improve the performance of distributed applications by reducing the data traffic between server and client installations. Please note that you must register a stored procedure with the database before it can be called by a client program.
In DatabaseSpy, ストアドプロシージャ that are registered with the database are displayed in a separate folder in the オンラインブラウザー. A コンテキストメニュー provides several maintenance options and, 更に、 facilitates the creation of SQL statements for creating, altering, dropping, or executing the stored procedure (次を参照: SQL ステートメントの生成).
DatabaseSpy provides sub-folders for the procedures where the parameters are displayed. The definitions can be edited and renamed in プロパティウィンドウ.
(C) 2019 Altova GmbH