Sql的增删改查

删除：

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)