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.
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
what are the reporting service components in SSRS?
What is data set in report?
How check triggers in sql server?
What is the difference between clustered and non-clustered indexes in ms sql server?
Difference between group by clause and having clause in SQL?
What is the use of nvl work?
How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?
How to create function without parameter in sql server?
What is use of except clause? How does it differ from not in clause?
What happens if null values are involved in datetime operations?
How to provide default values to function parameters?
Can you explain what is the use of custom fields in report?
What is sqlservr.exe - process - sql server (sqlex?press)?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
how to do partition in sqlserver