exec.sql

这是一个基于SQL平台的数据库程序

CREATE PROCEDURE [AddStuScore] (@XM varchar(6),@KCM varchar(16),@CJ int) AS
begin
	declare @KCH varchar(4)
	declare @XH varchar(6)

	select @KCH=KCH from KC where KCM=@KCM
	select @XH=XH from XS where XM=@XM
	select * from XS_KC where XH=@XH and KCH=@KCH
	if @@RowCount=1
		update XS_KC set CJ=@CJ where XH=@XH and KCH=@KCH
	else
		insert into XS_KC values(@XH,@KCH,@CJ)
end
return
GO