Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. How to update records of a table automatically based on date

How to update records of a table automatically based on date

Scheduled Pinned Locked Moved ASP.NET
databasesql-serversysadminhelptutorial
13 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Krishhhhhhhhhhhhhh

    Am using MS sql server 2005 database. Table has 3 columns: 1)Id 2)Status 3)ExpireDate If Expire Date is today then status has to become false otherwise true. It has to done automatically. How to do it? Please help me

    L Offline
    L Offline
    Lost User
    wrote on last edited by
    #2

    This was already posted in the General Database forum. Please post in one forum only.

    K 1 Reply Last reply
    0
    • L Lost User

      This was already posted in the General Database forum. Please post in one forum only.

      K Offline
      K Offline
      Krishhhhhhhhhhhhhh
      wrote on last edited by
      #3

      No one has answered for this question yet. If anybody knows answer it

      L 1 Reply Last reply
      0
      • K Krishhhhhhhhhhhhhh

        No one has answered for this question yet. If anybody knows answer it

        L Offline
        L Offline
        Lost User
        wrote on last edited by
        #4

        Krishhhhhhhhhhhhhh wrote:

        No one has answered for this question yet. If anybody knows answer it

        Be patient, this site isn't set up to provide immediate answers.

        K 1 Reply Last reply
        0
        • L Lost User

          Krishhhhhhhhhhhhhh wrote:

          No one has answered for this question yet. If anybody knows answer it

          Be patient, this site isn't set up to provide immediate answers.

          K Offline
          K Offline
          Krishhhhhhhhhhhhhh
          wrote on last edited by
          #5

          Then y u r there? I think To check cross post only?

          L 1 Reply Last reply
          0
          • K Krishhhhhhhhhhhhhh

            Then y u r there? I think To check cross post only?

            L Offline
            L Offline
            Lost User
            wrote on last edited by
            #6

            No, I'm looking for questions to answer, but when I read the same question more than once I (like many others here) point out that you are abusing the forums. There is a protocol to be followed here and maybe if you are new you are not aware of it. Read the guidelines[^] for more information.

            K 1 Reply Last reply
            0
            • L Lost User

              No, I'm looking for questions to answer, but when I read the same question more than once I (like many others here) point out that you are abusing the forums. There is a protocol to be followed here and maybe if you are new you are not aware of it. Read the guidelines[^] for more information.

              K Offline
              K Offline
              Krishhhhhhhhhhhhhh
              wrote on last edited by
              #7

              I am not new to this. Check ur database since how long am using this. then talk to me.

              L 1 Reply Last reply
              0
              • K Krishhhhhhhhhhhhhh

                I am not new to this. Check ur database since how long am using this. then talk to me.

                L Offline
                L Offline
                Lost User
                wrote on last edited by
                #8

                Krishhhhhhhhhhhhhh wrote:

                I am not new to this.

                Then you have no excuse for i) Crossposting ii) Not knowing the guidleines iii) being rude.

                K 1 Reply Last reply
                0
                • L Lost User

                  Krishhhhhhhhhhhhhh wrote:

                  I am not new to this.

                  Then you have no excuse for i) Crossposting ii) Not knowing the guidleines iii) being rude.

                  K Offline
                  K Offline
                  Krishhhhhhhhhhhhhh
                  wrote on last edited by
                  #9

                  I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                  B A A 4 Replies Last reply
                  0
                  • K Krishhhhhhhhhhhhhh

                    I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                    B Offline
                    B Offline
                    Bassam Saoud
                    wrote on last edited by
                    #10

                    He is right that you are cross posting (bad boy!)and you are right that he found the time to mention that you are crossposting but cant find the time to answer the question:)

                    1 Reply Last reply
                    0
                    • K Krishhhhhhhhhhhhhh

                      I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                      B Offline
                      B Offline
                      Bassam Saoud
                      wrote on last edited by
                      #11

                      I answerd your question:)

                      1 Reply Last reply
                      0
                      • K Krishhhhhhhhhhhhhh

                        I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                        A Offline
                        A Offline
                        Ashfield
                        wrote on last edited by
                        #12

                        Krishhhhhhhhhhhhhh wrote:

                        i) irresponsible

                        In what way?

                        Krishhhhhhhhhhhhhh wrote:

                        ii) For not answering my questions

                        It has been aswered. Also remember that nobody here is paid to answer questions, they do so out of kindness

                        Krishhhhhhhhhhhhhh wrote:

                        ) wasting my time

                        Well don't bother posting any more questions, particularly when you are so rude.

                        Bob Ashfield Consultants Ltd Proud to be a 2009 Code Project MVP

                        1 Reply Last reply
                        0
                        • K Krishhhhhhhhhhhhhh

                          I won't excuse u people for i) irresponsible ii) For not answering my questions iii) wasting my time

                          A Offline
                          A Offline
                          Abhijit Jana
                          wrote on last edited by
                          #13

                          Hi, Please don't be rude. Here every one try to help each other. So be polite while asking question or seeking for help. Thanks !

                          Abhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.

                          1 Reply Last reply
                          0
                          Reply
                          • Reply as topic
                          Log in to reply
                          • Oldest to Newest
                          • Newest to Oldest
                          • Most Votes


                          • Login

                          • Don't have an account? Register

                          • Login or register to search.
                          • First post
                            Last post
                          0
                          • Categories
                          • Recent
                          • Tags
                          • Popular
                          • World
                          • Users
                          • Groups