create table [tb]([col] varchar(10)) insert [tb] select '001234' union all select '2009-12-08' select * from tb where isdate(col)=1/** col ---------- 2009-12-08(所影响的行数为 1 行) **/
declare @var int set @var= isdate('g') if @var =0 print '不是有效日期' else print '是有效日期'
insert [tb]
select '001234' union all
select '2009-12-08'
select * from tb where isdate(col)=1/**
col
----------
2009-12-08(所影响的行数为 1 行)
**/
set @var= isdate('g')
if @var =0
print '不是有效日期'
else
print '是有效日期'