Data Type Validation Rules

I'm looking for the ability to check data types using a data validation rule. For example, I'd like to bring in all my data using NVARCHAR(MAX) and then leverage a data validation rule of ISNUMERIC or ISDATE to determine if the string is a number or date, respectively.  


Please sign in to leave a comment.