With simple example: begin try declare @int int set @int='select

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 / veeresh kethari

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

Answer Posted / veeresh kethari

With simple example:

begin try
declare @int int
set @int='select 1/0'
end try
begin catch
print 'Error detected with error number -'+convert(char
(10),@@error)
end catch

Is This Answer Correct ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is sparse columns of sql server 2008?

1057

What is the full form of ddl?

925

How to execute function in stored procedure sql server?

1154

Explain indexed views?

983

Name 3 ways to get an accurate count of the number of records in a table?

1039

What is an expensive query?

931

What is the difference between char, varchar and nvarchar?

1024

List out some of the requirements to set up a sql server failover cluster?

1034

Tell me the use of keyword with encryption. Create a store procedure with encryption?

1008

what is datawarehouse?

1114

Explain iaas, paas and saas?

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1005

What is the difference between Stored Procedures and triggers?

1082

How to call a function from a stored procedure in SQL Server ?

1029

Mention the different types of triggers?

1116