Results 1 to 3 of 3

Thread: How to make sure that the operation on database is successful?

  1. #1

    How to make sure that the operation on database is successful?

    Suppose there is Insert or Update or Delete operation is performed on a database table. How you make sure that the operation(Insert, Update or Delete) is successful?


  2. #2
    Junior Member
    Join Date
    Jan 2007
    Answers
    2

    Re: How to make sure that the operation on database is successful?

    using
    code:
    SELECT * FROM (name of table)

    to see did its realy add things that you are alraday adds


  3. #3
    Contributing Member
    Join Date
    Apr 2007
    Answers
    58

    Re: How to make sure that the operation on database is successful?

    If the transaction is not successful, you will get error message displayed like what you see in some web pages. In programming languages, like VB, if you execute sql statements through those language's built-in controls ie. ADODB, there are options to catch failed queries using properties/methods of those controls. Anyway a transaction will never be updated partially in SQL server, It will either updated fully or not at all.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact