环江环卫员工姓名电话查询 环卫工人联系方式

1)在 日期1 (2002-10-9) 到日期2 (2002-11-6) 之间迟到的员工姓名

select b.name

from T_Late a,T_Worker b

where a.WorkerId=b.WorkerId and a.latetime between '2002-10-9' and '2002-11-6'

2)查询员工姓名含有O的员工信息

select  *

from T_Worker

where o.name like '%O%'

3)更改员工号为00001的员工的姓名为Jack

update T_Worker set name='Jack' where WorkerId=00001

--如果WorkerID为字符串,where条件修改为 where WorkerID='00001'

4)迟到两次以上的员工号

select b.WorkerId

from T_Late a,T_Worker b

where a.WorkerId=b.WorkerId

group by b.WorkerId

having count(b.WorkerId )>2

5)没有迟到的员工信息（用Join)

select b.WorkerId,b.name,b.sex

from T_Late a join T_Worker b on a.WorkerId=b.WorkerId

group by b.WorkerId ,b.name,b.sex

having count(b.WorkerId )=0

6)编写触发器，当删除员工信息时，同时删除对应的迟到记录

create trigger AfterDelete_T_Worker on T_Worker after delete
as
declare
    @WorkerId int--这里假设workerid为int类型

    --从删除表中获取删除的员工id

    select @WorkerID=WorkerId

    from deleted

    --利用获取的员工id删除迟到记录

    delete from T_Late where WorkerId=@WorkerID

go

以上就是与环江环卫员工姓名电话查询以及环卫处的电话号码是多少的相关内容，看完环江环卫员工姓名电话查询一文后，希望这对大家有所帮助！