在学习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