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.
- 2 Answers
- 4354 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
What is sql collation?
What is the difference between SQL notification and SQL invalidation?
What are a database and a data warehouse?
How do I debug a stored procedure in sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
How do I uninstall sql server 2014?
What do you know about normalization and de- normalization?
What is blocking?
What do we have to check in database testing?
What is DCL?
What is the use of tempdb? What values does it hold?
Would you store your query in a ssrs report or a database server? State the reason why?
What is auditing in sql server?
Explain how dts is used to extract, transform and consolidate data?
List out the differences between global and local temp tables in sql server?
