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. Database & SysAdmin
  3. Database
  4. sql

sql

Scheduled Pinned Locked Moved Database
databasequestionlounge
12 Posts 8 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.
  • J Offline
    J Offline
    jeyaranjani
    wrote on last edited by
    #1

    random question retrival from database

    R J J R 5 Replies Last reply
    0
    • J jeyaranjani

      random question retrival from database

      R Offline
      R Offline
      R Giskard Reventlov
      wrote on last edited by
      #2

      You could always try asking a question.

      "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

      L 1 Reply Last reply
      0
      • J jeyaranjani

        random question retrival from database

        J Offline
        J Offline
        Jorgen Andersson
        wrote on last edited by
        #3

        How was your mushrooms yesterday?

        "When did ignorance become a point of view" - Dilbert

        G 1 Reply Last reply
        0
        • J Jorgen Andersson

          How was your mushrooms yesterday?

          "When did ignorance become a point of view" - Dilbert

          G Offline
          G Offline
          Gerben Jongerius
          wrote on last edited by
          #4

          I think you just answered his question. As this was a very random question :-D.

          1 Reply Last reply
          0
          • J jeyaranjani

            random question retrival from database

            J Offline
            J Offline
            J4amieC
            wrote on last edited by
            #5

            What can ORDER BY NewID() do? Wait, this isnt Jeopardy? Darn.

            1 Reply Last reply
            0
            • R R Giskard Reventlov

              You could always try asking a question.

              "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

              L Offline
              L Offline
              Luc Pattyn
              wrote on last edited by
              #6

              the OP does not have a question, he wants to get a question, a random one. :)

              Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

              Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

              R R 2 Replies Last reply
              0
              • L Luc Pattyn

                the OP does not have a question, he wants to get a question, a random one. :)

                Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

                Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

                R Offline
                R Offline
                R Giskard Reventlov
                wrote on last edited by
                #7

                I sets them up, he knocks them down... Hey: fix cp vanity: I'm sure you can't have anything better to do :-)

                "If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair. nils illegitimus carborundum me, me, me

                1 Reply Last reply
                0
                • J jeyaranjani

                  random question retrival from database

                  R Offline
                  R Offline
                  RaviRanjanKr
                  wrote on last edited by
                  #8

                  Why are you getting it in back-end move for front-end it will works.:suss:

                  G 1 Reply Last reply
                  0
                  • R RaviRanjanKr

                    Why are you getting it in back-end move for front-end it will works.:suss:

                    G Offline
                    G Offline
                    Gerben Jongerius
                    wrote on last edited by
                    #9

                    I don't completely agree with you, pending on the size and design structure of the question system. If you have multiple categories each containing a couple of thousand questions. Totalling in the millions then it would be less then optimal to do it in the application. Or a scenario where the same logic would have to reside in multiple applications. So doing it database or application side really depends on the setup of the entire application.

                    R 1 Reply Last reply
                    0
                    • L Luc Pattyn

                      the OP does not have a question, he wants to get a question, a random one. :)

                      Luc Pattyn [Forum Guidelines] [Why QA sucks] [My Articles] Nil Volentibus Arduum

                      Please use <PRE> tags for code snippets, they preserve indentation, and improve readability.

                      R Offline
                      R Offline
                      Rajesh Anuhya
                      wrote on last edited by
                      #10

                      :laugh: :laugh: :laugh:

                      Rajesh B --> A Poor Workman Blames His Tools <--

                      1 Reply Last reply
                      0
                      • G Gerben Jongerius

                        I don't completely agree with you, pending on the size and design structure of the question system. If you have multiple categories each containing a couple of thousand questions. Totalling in the millions then it would be less then optimal to do it in the application. Or a scenario where the same logic would have to reside in multiple applications. So doing it database or application side really depends on the setup of the entire application.

                        R Offline
                        R Offline
                        RaviRanjanKr
                        wrote on last edited by
                        #11

                        Yes This is your point of view and I 100 % agree with you.:suss:

                        1 Reply Last reply
                        0
                        • J jeyaranjani

                          random question retrival from database

                          R Offline
                          R Offline
                          RaviRanjanKr
                          wrote on last edited by
                          #12

                          jeyaranjani wrote:

                          random question retrival from database

                          :confused: Don't try to post like this always post with fact question Make a connection and get all data in your dataset and then use Random keyword and get all data from dataset in randomly way.

                          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