你这个是数据库设计问题
select top 10 * from question where selectname="难" order by newid()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~这些是什么意思?
select top 10 * from question where selectname="难" order by newid()
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~这些是什么意思?
解决方案 »
- webclient抓取网页时gridview分页怎么弄
- IIS测试网站出现了问题
- 急急急急!!!!!怎样将文本编辑器里的图片下载到本地
- 两个表如何先后添加到一个DataGrid中
- asp中数据库操作得困惑,请帮忙!
- 灾难性故障 (异常来自 HRESULT:0x8000FFFF (E_UNEXPECTED))
- 一个难题,希望有人捧场,分不够可以在给,关于自动生成列属性的dataGrid中设置隐藏列
- treeview是不是要有许可证???
- ORACEL数据库取值的问题。在线等(揭帖率100%),分不够另外加。急!!!!!
- 发布一个简单的ComboBox的原代码,我想对正在学控件编程的朋友都有参考用途:
- 我把我所有的分都给你们了。
- DataGrid控件的"URL格式字符窜"设置
order by newid() can gurantee the result is random.newid will generate new value of guid type, and the result will be unique and random, it is a function! not a field!
2. what if i want display different feedback based on the choice user choosed?
3. what if each choice will be graded differently
(choise a: 5 point, choice b: 4 point, choice c: 3 point .....)
4. what if I want questions of multiple reponse(answer) or fill in blank type?
5. do you plan to support html code in your question and answers?by the way, the names of your fields are funny. Timu is pingying, answer is english, inconsistent.
哦,昨天发帖太匆忙,漏写了!现更正如下:
我在数据库中建的question表,该表有如下字段:id,timu,A,B,C,D,answer,selectname
id:题目的自动编号;
timu:存放题目;
A,B,C,D:分别存放单选题的四个选项内容;
answer:存放正确答案;
selectname:存放试卷的难度系数 还有,"select top 10 * from question where selectname="难" order by newid()"语句可是高手指点的绝对正确,我已试过了!