sql2000数据库中提取正确答案

来源：百度知道 编辑：UC知道 时间：2024/09/25 05:32:25
微机考试系统用的是sql做数据库，学生机随机抽取试题，有没有办法在学生机上把随机抽取的到试题，相对应的答案从数据库中下载到学生机，只需要单选和判断

不行

create proc p_tm5
as

----------------------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kaojuan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[kaojuan]

CREATE TABLE [dbo].[kaojuan] (
[sid] [int] IDENTITY (1, 1) NOT NULL ,
[sno] [int] NULL ,
[timu] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[tixing] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
----------------------------------------------------
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[daan]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[daan]

CREATE TABLE [dbo].[daan] (
[sid] [int] IDENTITY (1, 1) NOT NULL ,
[sno] [int] NULL ,
[answer] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

-