删除:
1.删除表中所有数据(标识值不会重置)
delete 表名
delete FAReportInfos where IsDeleted=1
2.条件删除
delete 表名 where
3.删除表数据,重置表(标识值也会重置)
truncate table 表名
修改:
1.全部修改
update 表名 set
2.条件修改
update 表名 set 字段 where
字符串替换
//将某个字段中的某个字符串替换
update UserInfos set Education=REPLACE(education,'aaa','bbb')
根据日期来筛选
select DDate from (select convert(nvarchar(50),Laiyangshijian,120) DDate from FAReportInfos ) as temp
where DDate between '2022-10-01' and '2022-11-01'
select * from FAReportInfos where IsDeleted=0 and
(Mingcheng like '%陶瓷电容器%' )
and Laiyangshijian in
(select DDate from (select convert(nvarchar(50),Laiyangshijian,120) DDate from FAReportInfos ) as temp
where DDate between '2022-03-03' and '2022-04-01')
查询
select count(1) from FAReportInfos
select * from FAReportInfos
where Hetong='FX0422-09215'
外观图片是否取到
select len(Waiguanpic) 长度,Waiguanpic ,Hetong from FAReportInfos
order by len(Waiguanpic)