SQL语句输入学号后得到成绩

[ynjye]

use st
go
create functiong fun_grade(@sno int)
returns int
As
begin
declare @sno int
@resture int
set @grade=(select grade frome sc where @sno=
@cno)
resurt @grade

调用此函数，在SQL　server查询分析器中输入
学号查出成绩。

[让你望见影子的墙]

declare @t int
set @t=dbo. fun_grade(学号)

[dtxh168]

declare @t int 
select @t=dbo. fun_grade(学号) 

[dawugui]

declare @t int
set @t = ...
set dbo.fun_grade(@t)

[baihuling2008]

declare @t int
select @t=dbo. fun_grade(学号)

[dawugui]

declare @t int
set @t = ...
select dbo.fun_grade(@t)

[ChinaJiaBing]

declare @cj decimal(10,2)
set @cj= dbo.fun_grade(学号)
select @cj

[--小F--]

declare @t int 
select @t=dbo. fun_grade(学号)

[daiyueqiang2045]

[Quote=引用 7 楼 fredrickhu 的回复:]
SQL codedeclare@tintselect@t=dbo. fun_grade(学号)
[/Quote]
同意

[freeman_lau]

顶

[wxj5595159]

declare @t int
select @t=dbo. fun_grade(学号)

[wxj5595159]

[code=SQL][declare @t int
select @t=dbo. fun_grade(学号)]

[wxj5595159]

[code=SQL][/code
declare @t int
select @t=dbo. fun_grade(学号)
]

[cxmcxm]

create functiong fun_grade(@sno int) 
returns int 
As 
begin 
declare @sno int, 
        @resture int 
set @grade=(select top 1 grade from sc where @sno= 
@cno) 
return @grade 
end

[NDDavid]

declare @t int
select @t=dbo. fun_grade(学号)

[Guardians]

--

[qqqwwwqw]

declare @t int
select @t=dbo. fun_grade(学号)

[cashfly]

[Quote=引用 13 楼 cxmcxm 的回复:]
create functiong fun_grade(@sno int)
returns int
As
begin
declare @sno int,
@resture int
set @grade=(select top 1 grade from sc where @sno=
@cno)
return @grade
end
[/Quote]

declare @temp int 
select @temp=dbo. fun_grade(学号)

[忆轩辕]

declare @sno int
set @sno = ...
select dbo.fun_grade(@sno)

[小栗色兔子]

ding...