2018-08-03

2018 年 8 月 3 日2018 年 8 月 3 日 by 沧海之树 In 工作

select * from H_TMK where sZXGW='1852'

select * from H_Employee where sname like '%周%'

select * from H_Employee where sEmpNo='1852'

update H_TMK set sZXGW='1857' where sZXGW='1852'
1857 韩林
1852 陈欣妮

select * from H_TMK_GZ where sOP='1852'

update H_TMK_GZ set sOP='1857' where sOP='1852'

select * from H_TMK_GZ with (nolock)

select * from TrackedRecord

select * from Employee where Name like '%周%'

select * from EmployeeID

insert into bh20180529.dbo.EmployeeID values('1293','00452')

select * from ArrearsDetails;

select * from H_Employee where sname like '%周%'

select * from CustomerBaseInfo;