select
字段1=case when 字段A in('sysadmin','cc','dd') then 字段A end,
字段2=case when 字段A in('登出','登录','重新登录','导入','创建') then 字段A end,
字段3=case when isdate(字段A)=1 then 字段A end,
字段4=case when 字段A like '%零部%' then 字段A end
from 字A
declare @t table(a varchar(50))
insert into @t select '2006-03-27 20:10:50'
union all select '登出'
union all select '2006-03-27 20:12:17'
union all select '登出'
union all select 'sysadmin'
select a,
b=case when isdate(a)=1 then '是' else '不是' end
from @t