人力資源數(shù)據(jù)庫(kù)設(shè)計(jì)計(jì)劃書(shū)-資料下載頁(yè)
2025-08-03 08:31本頁(yè)面
【正文】 理39。)insert into worklive (Company,work_Time,Position,Memo) values (39。本公司39。,39。七個(gè)月39。,39。主管39。,39。核心主管39。)insert into worklive (Company,work_Time,Position,Memo) values (39。本公司39。,39。十一年七個(gè)月39。,39。經(jīng)理39。,39。核心經(jīng)理39。)四， 存儲(chǔ)過(guò)程代碼列表（1） 樣例工資表（視圖與過(guò)程）輸入員工姓名和月、年份得到該員工的該年月工資情況。創(chuàng)建工資表視圖create view samsarlaryas select 39。員工編號(hào)39。= ,39。姓名39。= , 39。部門(mén)39。= ,39?；竟べY39。=,39。崗位工資39。=,39。資金工資39。=,39。交通補(bǔ)貼39。= ,39。養(yǎng)老保險(xiǎn)39。=,39。失業(yè)保險(xiǎn)39。=,39。個(gè)人所得銳39。=,39。應(yīng)發(fā)工資39。=,39。實(shí)發(fā)工資39。=,39。工資月份39。=, 39。年份39。=from Sarlary a , Employee b , Department cwhere = and = select * from samsarlary創(chuàng)建過(guò)程create procedure samsarlary2@x varchar(20)= 39。%39。 ,@y varchar(20)=39。%39。 , @z varchar(20)=39。%39。as beginselect 員工編號(hào),姓名,部門(mén),基本工資,崗位工資,資金工資,交通補(bǔ)貼,養(yǎng)老保險(xiǎn),失業(yè)保險(xiǎn),個(gè)人所得銳,應(yīng)發(fā)工資,實(shí)發(fā)工資,工資月份,年份from samsarlarywhere 姓名 like @x and 工資月份 like @y and 年份 like @zend創(chuàng)建工資表過(guò)程create procedure samsarlary2@x varchar(20)= 39。%39。as beginselect 員工編號(hào),姓名,部門(mén),基本工資,崗位工資,資金工資,交通補(bǔ)貼,養(yǎng)老保險(xiǎn),失業(yè)保險(xiǎn),個(gè)人所得銳,應(yīng)發(fā)工資,實(shí)發(fā)工資,工資月份from samsarlarywhere 姓名 like @xend測(cè)試執(zhí)行樣例工資表（視圖與過(guò)程）exec samsarlary2 @x=39。xx39。,@z=39。199039。插入語(yǔ)句insert into Employee (emp_name)values (39。xx39。)select * from Employeeinsert into Department(dname)values (39。yy39。)select * from Departmentinsert into sarlary (emp_id,dep_id,basewage,poswage,bonus,trafsub,idleins,pertax,sdate,syear)values (1,1,1,2,3,4,5,6,39。739。,39。199939。)select * from sarlary(2)各部門(mén)工資年報(bào)表（視圖與過(guò)程）輸入部門(mén)名和年份得到該部門(mén)全年工資表select * from Sarlaryselect * from Department創(chuàng)建過(guò)程create procedure yearbiao1 @x varchar(20),@y varchar(20)as select distinct 39。部門(mén)39。= (select dname from Department where dname = @x),39。一月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。139。 and =@y ),39。二月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。239。 and =@y ),39。三月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。339。 and =@y ),39。四月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。439。 and =@y ),39。五月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。539。 and =@y ),39。六月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。639。 and =@y ),39。七月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。739。 and =@y ),39。八月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。839。 and =@y ),39。九月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。939。 and =@y ),39。十月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。1039。 and =@y ),39。十一月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。1139。 and =@y ),39。十二月39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =39。1239。 and =@y ),39。總計(jì)39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =@y )from Sarlary a , Department bwhere = and dname = @x and =@y測(cè)試執(zhí)行各部門(mén)工資年報(bào)表（視圖與過(guò)程）exec yearbiao5(3) 輸入部門(mén)名和月份，年份，輸出當(dāng)年月該部門(mén)的員工工資總和 創(chuàng)建過(guò)程create procedure t @x varchar(20) , @y varchar(20),@z varchar(20)as select distinct 39。部門(mén)39。= ,39。月份39。= ,39。年份39。=,39。總計(jì)39。=(select sum(Rpay) from Sarlary a , Department b where = and = @x and =@y and =@z)from Sarlary a , Department b where = and = @x and =@y and =@z 15 /
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1