wolfmaster

declare @a nvarchar(100) set @a='大' select patindex('%[^吖-做]%',@a) set @a='aaa' select patindex('%[^吖-做]%',@a)

在HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\ Control\Session Manager中找到PendingFileRenameOperations项目，并删除它。这样就可以清除安装暂挂项目。

select checkPerson,sum(case when isvalidate='Y' then 1 else 0 end ) as 'pass',sum(case when isvalidate='D' then 1 else 0 end ) as 'reject',count(*) '所有' from t_audit_check_audit group by checkPerson ...