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 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