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

    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