工資數(shù)據(jù)庫(kù)管理系統(tǒng)(參考版)
2024-09-11 10:34本頁(yè)面
【正文】 ) 示例： 。) and =39。+39。, , from employeebaseinfo,employeepay,position,departmentinfo where (= and = and = and =(39。, (+++ ty ) as 39。,(+) as 39。, (+++afety+ ) as 39。) 示例 ： b、某部門(mén)員工月份工資： 代碼： CREATE view departmentemployeepay_view AS select ,_id, (+) as 39。+39。, , from employeebaseinfo,employeepay,position where (= and = and =39。, (+++ ty ) as 39。,(+) as 39。, (+++afety+ ) as 39。)and =department_id group by end GO 示例： 視圖功能塊： 15）瀏覽工資信息表（每個(gè)月份 所有員工或 某個(gè)部門(mén)員工的工資信息） a、所有員工月份工資： 代碼： CREATE view employeemonthpay_view AS select ,_id, (+) as 39。 from employeebaseinfo inner join employeepay on = inner join position on = where =convert(smalldatetime,midyear_id +39。) select , sum(++++ )as 39。 from employeebaseinfo inner join employeepay on = inner join position on = where =convert(smalldatetime,midyear_id +39。 from employeebaseinfo inner join employeepay on = inner join position on = where convert(char(7),year())=midyear_id and =department_id group by end else begin if len(midyear_id)=6 or len(midyear_id)=7 select sum(+++ ++ )as39。 from employeebaseinfo inner join employeepay on = inner join position on = where convert(char(7),year())=midyear_id select , sum(++++ )as 39。 return end if len(midyear_id)=4 begin select sum(+++ ++ )as39。請(qǐng)重新輸入。 39。 GO 示例： 14)企業(yè) 年 /月工資匯總（實(shí)現(xiàn)的功能是匯總某年總的工資支出及某年的某月工資匯總） 及各部門(mén)年 /月工資匯總 代碼： CREATE PROCEDURE panyordepartment_payout midyear_id char(7), department_id char(4) AS if midyear_id is null or department_id is null begin print39。已經(jīng)查詢到該月份員工工資的信息。139。 39。 end print 39。 GO 示例 ： 12） 員工工資修 改 代碼： CREATE PROCEDURE updateemployeepay AS begin update employeepay set prize=3000,subsidy=5000 where employee_id=39。的員工的工資信息。已經(jīng)刪除員工編號(hào)為 39。 39。 return end begin tran insert employeepay (midyear,employee_id,posi
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1