20180804

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

select * from CustomerBaseInfo

select * from ItemInfo where ID='00553'

select * from ItemInfo where ID='00366'

update ItemInfo set Valid=0 where cast(ID as int)>=834 and cast(ID as int)<=848

select cast(ID as int) id from ItemInfo where id<100 order by cast(ID as int);

select * from YUN_HIS20180719.dbo.H_Project_Data where StopFlag=1 --KID='12090221061706937'

select * from bh20180529.dbo.ItemInfoID where Original='12090221061706937'

--select * from

update ItemInfo set Valid=0 where ID in
(select a.Now from bh20180529.dbo.ItemInfoID a inner join YUN_HIS20180719.dbo.H_Project_Data b on a.Original=b.KID where b.StopFlag=1)

select * from ItemForConsultingCategory