How to install the SQL stored procedure execution status and return it to Delphi

The stored procedure can be used for implementation, that is, the output parameters of the stored procedure. For details, see the demonstration, creation process, and calling process to obtain the output parameters: -- create proc SSB @ flag int outputastruncate table ffinsert into ffselect * From DBO. stuinfo if @ rowcount> 0 -- obtain the number of affected rows, indicates that the data is successfully inserted. beginset @ flag = 0 -- the execution is successful. endelsebeginset @ flag = 1 -- the execution fails. endreturn @ flag -- the returned value of the process. Go -- call the stored procedure, return Value: declare @ flag int exec SSB @ flag outputselect @ flag -- Return Value