Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5047 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
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is dml command?
What is self contained multi valued query?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
What are alternate keys?
What are the differences between decimal and float in ms sql server?
Can we linked SharePoint to a SQL database?
What is the purpose of grouping data in a report?
What are the general features of sql server management studio? : sql server management studio
Can we insert data if clustered index is disabled?
 Explain what is sql override for a source taLle in a mapping?
Can you use order by when defining a view?
How to download and install microsoft sql server management studio express?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
Can you explain full-text query in sql server?
