Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-25 : 12:18:18
|
| melbin writes "hi i am using sql seve7.0.i need to give a message in the frontend when a record isinserted or updated into a table.i have written the quries for insertion and updation inside a storedprocedure,can i return somethig from that stored procedureso that i can show a message in the frontend that a transactionis done by someone.i am using delphi as front end.helpbyepaul" |
|
|
KnooKie
Aged Yak Warrior
623 Posts |
Posted - 2002-04-25 : 12:28:34
|
| You can declare a variable as an Output variable within a Stored Procedure.(see books on-line for more info.)CREATE PROCEDURE usp_Test@InputVariable varchar(10),@OutputVariable varchar(10) OUTPUTAS..............Paul |
 |
|
|
|
|
|
can i Return something from a storedprocedure