How can I display a message in stored procedure.

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

Iam writing a stored procedure for insert operation. So, I need to display a confirmation message that record inserted successfully. Any one can help me.

Posted 6-Dec-12 22:44pm

bapu_reddy

Add a Solution

Comments

choudhary.sumit 7-Dec-12 4:48am

do you have any front end?

3 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)

Patel Shailendra · Answer 1 · 2012-12-06T23:01:00

Solution 2

Create procedure Demo( parameter,...)
as
begin
insert into table_Name values('a');
print 'inserted successfully';
end

Posted 6-Dec-12 23:01pm

Patel Shailendra

Member 10017719 · Answer 2 · 2014-04-08T21:46:00

Solution 3

Declare @id int
INSERT INTO TableName(condition)
SELECT @id=SCOPE_IDENTITY()

IF(@id is not null)
SELECT ISNULL(@id,'')[Message]

-- That Message should be declared in frontend as return param

HOPE ITS CLEAR

Posted 8-Apr-14 21:46pm

Member 10017719

Krunal Rohit · Answer 3 · 2012-12-06T22:51:00

Solution 1

http://stackoverflow.com/questions/11867551/display-error-message-using-stored-procedure

See the link

Posted 6-Dec-12 22:51pm

Krunal Rohit