SQL Data Type Check

SELECT ISNUMERIC(123) -- 1
SELECT ISNUMERIC('test') -- 0

SELECT ISDATE('2019-01-01') -- 1
SELECT ISDATE('test') -- 0
SELECT ISDATE('01/01/2019') -- 1
SELECT ISDATE('01/01/2019 11:00PM') -- 1