none
HOW TO SHOW MESSAGE AFTER INSERT QUERY??

    Question

  • Heloo all,

                  Actually i want to user submit the report in ones in a day,I execute insert query according to condition its works.but my problem is when user submit again report on same day he got message"you have not submit the report".How i can use this exception ???? please help me..

    Thursday, July 12, 2012 5:41 AM

Answers

  • Hi,

    You can use RaiseError function in SQL Server (in your SP or your script) after you check the condition raise the error with specified severity.

    I you using programming language like C# and so on you can show message with in the exception.

    I hope this is helpful.


    Please Mark it as Answered if it answered your question
    OR mark it as Helpful if it help you to solve your problem
    Elmozamil Elamir Hamid

    MCTS: SQL Server Administration/Development

    MyBlog

    • Proposed as answer by vr.babu Thursday, July 12, 2012 7:24 AM
    • Marked as answer by starnitin Friday, July 13, 2012 8:02 AM
    Thursday, July 12, 2012 5:53 AM