SELECT * FROM equip_center where Center_name is not NULL
select * from test1 where centerid in(select centerid FROM center where name='a')
update test1 set name='b' from test1 inner join center on test1.centerid=center.centerid
where center.name='a'
SELECT * from vw_tb_project WHERE jp LIKE '%HY%'
declare @Meter_id int;
insert into Equip_meter (Meter_type_id,Meter_no,Mpid,Center_id,Az_date,Remarks,Flag, CreateDate, CreateUserId) values('1','2','4','5','2017-06-29','fasd',1,GETDATE(),'12') select @Meter_id=@@identity;
insert into Yb_house_meter(House_id,Meter_id,CreateUserId) values('12', @Meter_id,'2') select @Meter_id;