请教一个简单存储过程的写法! ( 积分: 30 )

X

xzb_97

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #1

我在SQLSERVER2000中建立了一个表traininfo,里面表结构为
trainno price
1 30
2 20
3 10
现在我要找到最小的price以及相对应的trainno,分别输出到edit1.text和edit2.text中,这个存储过程该怎么写啊?
我假设输出的参数为@no和@p.以及大家通常是怎么调试一个存储过程的也请大家帮忙说一下!

 

X

xzb_97

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #2

请大家帮忙!

 

F

felicity

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #3

select @no= min(price), @p = trainno from traininfo

 

A

asksomeone

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #4

create proc xx
as
select * from traininfo where trainno in(select min(trainno) as trainno from traininfo)

{然后你选出来了}

 

X

xzb_97

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #5

是不是还要加上:
create procedure train @no int(20),@p int(20)
as
select @no= min(price), @p = trainno from traininfo ???这样才算完整的一个存储过程?

 

X

xzb_97

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-06-11

• #6

那如果我想直接在存储过程里将选出的@no,@p(它们本来是int),直接convert成varchar,该怎么写?