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
- 4355 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
Explain the use of containers in ssis and also their types?
What is difference between line feed ( ) and carriage return ( )?
What is an indexing technique?
Do you know query execution plan?
What is the usage of sign function?
What do you understand by hotfixes and patches in sql server?
Explain how to integrate the ssrs reports in application?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the difference between cube operator and rollup operator? : SQL Server Architecture
What is difference between count (*) and count column?
What is a natural primary key?
Tell me what is use of except clause? How it differs from not in clause?
ow to bring suspect mode datbase online from scratch
What is extent? Types of extents?
