创建:
create table cfg_devicetemp(
id int identity(11) primary key not null ,
devicename nvarchar(50),
updatetime datetime(23)
)
查询:
select * from cfg_devicetemp
插入:
insert into
cfg_devicetemp(id,devicename,updatetime) values ('8','充电枪','2022-12-16 14:43:47.08');
更新:
update cfg_devicetemp set
id='9',
devicename='集控',
where id=8
删除:
id之间: delete from cfg_devicetemp(表) where id >=9312 and id <=10040
delete from cfg_devicetemp where id =9418
delete from cfg_devicetemp where id >=9418
关键字: delete from cfg_devicetemp(表) where devicename(键) like '%哈%'
delete from cfg_devicetemp where devicename like '%AC2209%'