Table of Contents
Write / on an empty line to enter a stored procedure, stored function, or database trigger.
drop procedure if exists DEPT / create procedure DEPT() begin select * from dept; end / call DEPT() /
Presuming table dept is available in the selected database, the code above will show three tabs:
- Result of the drop procedure command
- Result of the create procedure command
- Result of the procedure call
Can i execute a stored procedure which is in SQL Server database from WP Data Access ?
Sorry Markos, that’s not possible. You should be able to use stored procedures in your database triggers, but I’m not sure how custom errors are passed. Never tried myself. But I would be greatful if you can share valuable information… 😉