Loading ...
Sorry, an error occurred while loading the content.

Re: [SQLQueriesNoCode] Immidiate Question?

Expand Messages
  • Muhammad Asif Akbar
    Use the procedure and in procedure use the switch statement for check the value of the field which are coming to update are empty or have value. if have value
    Message 1 of 5 , Oct 11, 2011
    • 0 Attachment
      Use the procedure and in procedure use the switch statement
      for check the value of the field which are coming to update are empty or have value. if have value then update this field with the coming value
      otherwise update the field with the original one...



      ________________________________
      From: Travis Truax <travis.truax@...>
      To: SQLQueriesNoCode@yahoogroups.com
      Sent: Tuesday, 11 October 2011 6:58 PM
      Subject: Re: [SQLQueriesNoCode] Immidiate Question?


       
      Definitely don't write an individual update for each column.

      ----- Original Message -----

      From: "y_sh_1984" <y_sh_1984@...>
      To: SQLQueriesNoCode@yahoogroups.com
      Sent: Tuesday, October 11, 2011 12:56:08 AM
      Subject: [SQLQueriesNoCode] Immidiate Question?

      Hi . I have a Table that has 10 fields . I want to update this table but
      8 fields can be updated .Now I have this question : "Should i write a separate procedure to update each field or i can write one procedure to update all of them ?"
      please help thanks a million

      ------------------------------------

      Yahoo! Groups Links

      [Non-text portions of this message have been removed]




      [Non-text portions of this message have been removed]
    Your message has been successfully submitted and would be delivered to recipients shortly.