You can use RaiseError or use the TRY CATCH Programming in the Stored Pro

How to handle errors in Stored Procedures. I want to display
a message to the user in the .aspx page that is calling a
stored procedure in it's code behind. please help me.

Question Posted / bru medishetty

2 Answers
4799 Views
247Customer, I also Faced
E-Mail Answers

Answer Posted / bru medishetty

You can use RaiseError or use the TRY CATCH Programming in
the Stored Procedure Code.

Thanks,
Bru Medishetty
www.LearnSQLWithBru,com

Is This Answer Correct ?

2 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Explain activity monitors

1004

What is recompile sql server?

989

What is the difference between dropping a database and taking a database offline?

1116

What is the recovery model? List the types of recovery model available in sql server?

843

Explain what is the main purpose of having conversation group?

880

Tell me what is the difference between locking and multi-versioning?

971

What is the stuff?

948

Explain atomicity?

973

What are the new data types are introduced in sql 2000?

859

Explain what is the function of sql server agent windows service?

942

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

1002

Insert syudents details in table.Current system date &time insert into joining time.How do insert?( in sysdate only return current system date how do add time?)

1801

Explain go command in sql server?

966

How to optimize stored procedure optimization?

843

Explain about temporary stored procedure?

934