select'查看' as 操作, ID as 编号, SN as 序列号,ErrorInfo as 错误信息,reverse(left(reverse('/'+FileDir),(charindex('/',REVERSE('/'+FileDir),1)-1))) as 附件,CreateTime as 创建时间,State as 状态,'删除'as 删除 from MIGnet4_0Bug where 1=1
字段FileDir的值为C:/abc/123.rar
截取后为123.rar
select'查看' as 操作, ID as 编号, SN as 序列号,ErrorInfo as 错误信息,reverse(left(reverse('/'+FileDir),(charindex('/',REVERSE('/'+FileDir),1)-1))) as 附件,CreateTime as 创建时间,State as 状态,'删除'as 删除 from MIGnet4_0Bug where 1=1
字段FileDir的值为C:/abc/123.rar
截取后为123.rar