create function score_table().sql

在学习SQL Server过程中整理的T-SQL语句

create function score_table
(
@sno char(10)
)
returns @score table
(
xs_id char(6),
xs_name char(8),
kc_name char(16),
xf tinyint,
cj tinyint
)
as
begin
    insert into @score
           select XS.sno,XS.sname,KC.cname,KC.credit,XS_KC.score
                from XS,KC,XS_KC
                     where XS.sno=XS_KC.sno and KC.cno=XS_KC.cno and XS.sno=@sno
    return
end