Algumas validacaoes no T-SQL…

ISDATE
Valida se a data é valida

if isdate(‘2008-44-01’) = 1
begin
select ‘s’
end
else
begin
select ‘n’
end


ISNUMERIC

Valida se eh numerico

if ISNUMERIC(‘aaa’) = 1
begin
select ‘s’
end
else
begin
select ‘n’
end

vlw