can i Return tigger value from storeproceudre

You can use Return statement. It only returns integer values so you will have
to designate what number will constitute success, failure and/or otherwise.
Then it is a matter of how you get the return value from whatever DB access
library you are using. You can also raise errors or use output parameters
as alternatives.

"paul" <melbinpaul@indiatimes.com> wrote:
>
>hi,
>
>i am using Sql server 7.0.When i insert or update a record in a table,i
>need to
>
>show a message in the front end ,that one record is added to the table.
>
>i have written the queries for insertion and updation into the table in
a
>storedprocdure.
>
>is there any way to return something from a storedprodure ,so that i can
>show a
>
>message in the frontend, that a record is upadted by someone.
>
>delphi is my frontend.
>
>help
>
>paul
>