How to handle exception in stored procedure in sql

Question

Hi frnds Please give the example for exception handling in stored procedure.which I can explain an interview. I went for the interview they asked me this qus I said to them and like try catch ,but they didn't satisfied.please give me example

Answer 1

I'm not sure what you mean by the 'reference file used' as that's just something I happen to know from my own efforts using Word or Excel interop.

However, I found a Microsoft Support link here which confirms the 'using directive' point (paragraph 7) and also contains some sample code which you may find useful:

http://support.microsoft.com/kb/316384

Answer 2

Hullo Vulpes,
Thank you very much for sharing information with me. Appreciate your help very much.

I will try our your suggested coding and will return to you with the result.
Can you please share with me the REFERENCE FILE USED ?


If my application is working, I will post the Overall coding here to share with other Newbies who have similar problems.


cheers,
Lennie

Answer 3

I'd replace this 'using' directive:

  

   using Microsoft.Office.Interop.Word;

with this one:

   using Word = Microsoft.Office.Interop.Word;

Code like this should then work (note that it's 'Word' not 'Words'):

   private Word.Application objWord;

   private Word.Document objDoc;

   private Word.Table objTable;

   private Word.Range objTableRange; 

Answer 4

Hi Suthish,
I have tried your suggestion when I develop the application and it generate this error message. that's the reason why I posted my problem earlier. Thanks anyway for trying to help me.

This is the earlier Posting:
Error messages generated:
Error 1 The type name 'Application' does not exist in the type 'Microsoft.Office.Interop.Word.Words'

Answer 5

try.. Words.Application objWord = new Words.Application();