能在DataTable 执行 复杂SQL语句吗？SQL code: create table test ( col varchar(100) ) insert test select '2009-1-1' union select '2009-10-2' union select 'sadsa' union select '20091' go select * from test where ISDATE(col)<>1 /* col ---------------------------------------------------------------------------------------------------- 20091 sadsa*/
筛选不合法数据 如果是筛选不合法的数字数据 采用 isnumeric SQL code: select * from tb where isdate(日期字段)=1
