数据库其他关键字使用

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;