Showing message using store procedure

Question

1.00/5 (3 votes)

See more:

Is it possible to show message in store procedure like C#. If possible please explain with example. Advance thanks for your kind response.

Posted 9-Sep-13 0:04am

Sumon562

Add a Solution

Comments

Sumon562 9-Sep-13 6:14am

I expect an answer.

[no name] 9-Sep-13 6:24am

If you expect an answer then you should provide the information need to give you an answer. Use the Print command. If you mean some thing like a messagebox from you server then no. You need to explain what it is that you trying to do.

Harshil_Raval 9-Sep-13 6:16am

in stored procedure you can use print command to print your message. e.g. print('test')

Sumon562 9-Sep-13 6:22am

Actually I use the store procedure in C# code and in the else portion of the store procedure will show a message. How can I do that

Mubin M. Shaikh 9-Sep-13 8:37am

Hi ,

You can use output to send value from your stored procedure to your C# code, and there you can use message box, or if you are working in SSMS then you can go for Print command at appropriate place to print value in SSMS environment.

Need some more detail what exactly you want to do.
Regards
Mubin Shaikh

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2013-09-09T22:53:00

Solution 1

Use OUT Parameter[^]

Posted 9-Sep-13 22:53pm

thatraja

Rakesh Meel · Answer 2 · 2013-09-09T23:36:00

Solution 2

visit here...

http://www.dotnetcurry.com/ShowArticle.aspx?ID=344[^]

Posted 9-Sep-13 23:36pm

Rakesh Meel