How to select a single Random Record each time in Query in SQL Server

shameer

SOLVED CLOSED ACTIVE ANSWERED
User: shameer
Posted: on Mar 25, 2013 05:41 AM
Forum: SQL Server
Answer: 1
Views: 3470

Hi all, i am designing a web site for online test..

Here I have, two types of Questions, 1. Textual Questions, and 2. Second type is Image based Question.. My database design is like below

QID,Question,OptionA1,OptionA2,OptionB1,OptionB2,OptionC1,OptionC2,OptionD1,OptionD2,Correct option here OptionA1, OptionB1, etc., contains Textual options... same way OptionA2, OptionB2, etc., contains Image based options here i am able to generate Random ID by using below SQL Query.. Select QID from Table_Name order by NEWID(); I am using asp.net 3.5, c# and SQL server.. My Question is how can generate random questions at the time of taking test.. example Q1 - should be with Textual options Q2 - should be with Image options Thanks

Download FREE API for Word, Excel and PDF in ASP.Net

RkHirpar...

0 1

Reply
ANSWER
User: RkHirpara
Replied: on Mar 25, 2013 05:58 AM
Report

Hi Shameer,

Please look at the following query.

DECLARE @tbl TABLE
(
	question_type VARCHAR(10)
)

INSERT INTO @tbl VALUES('Textual')
INSERT INTO @tbl VALUES('Image')

DECLARE @QuestionType VARCHAR(10)
SELECT @QuestionType = question_type FROM @tbl ORDER BY NEWID()

SELECT @QuestionType

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

Using above query you will get question type randomly so then using Case or IF Else you may get columns of interest.

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

How to select a single Random Record each time in Query in SQL Server

Company

Explore

Follow us

Contact Us