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 |
|
amos
Starting Member
5 Posts |
 Posted - 2009-10-20 : 11:51:10
|
| hi all,i'm writing a stored procedure, and i want to display a message,is there a command to do so?thank's a lot. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2009-10-20 : 12:17:37
|
| what exactly is it you want to accomplish...display a variable value? who do you want the message to be displayed to? etc<><><><><><><><><><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
amos
Starting Member
5 Posts |
Posted - 2009-10-20 : 12:24:02
|
| display a message such as: 'the user exist' or 'the user does not exist'. can i display it to the user somehow?thank's. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-20 : 12:56:59
|
| yup. you cant. just check for user using IF EXISTS and use RAISERROR to show message otherwise |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2009-10-21 : 04:14:20
|
quote:
Originally posted by visakh16
yup. you cant. just check for user using IF EXISTS and use RAISERROR to show message otherwise
cant should be can. Right?  MadhivananFailing to plan is Planning to fail |
|
|
|
amos
Starting Member
5 Posts |
Posted - 2009-10-21 : 04:43:08
|
| hi, i guess he meant that i can do it.thank's all. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-10-21 : 12:11:56
|
quote:
Originally posted by madhivanan
quote:
Originally posted by visakh16
yup. you cant. just check for user using IF EXISTS and use RAISERROR to show message otherwise
cant should be can. Right? MadhivananFailing to plan is Planning to fail
yup...  |
|
|
|
|
|
|
display a message in a stored procedure