jintiesetup.sql

来自「班主任考核管理系统」· SQL 代码 · 共 12 行

CREATE PROCEDURE jintiesetup
(@base numeric(18,0),@lihui numeric(18,0),@banhui numeric(18,0),
@koufen numeric(18,0),@qinshi numeric(18,0),@cailiao numeric(18,0),@huodong numeric(18,0),
@jititongbao numeric(18,0),@qita numeric(18,0),
@class char(20),@riqi datetime,@heji numeric(18,0)
) 
AS
	insert jintie(base,lihui,banhui,koufen,qinshi,
cailiao,huodong,jititongbao,qita,class,riqi,heji)
values(@base,@lihui,@banhui,
@koufen,@qinshi,@cailiao,@huodong,
@jititongbao,@qita,@class,@riqi,@heji)