An example to the problem:
There are 3 columns present in my SQL database. 

```
+-------------+------------------+-------------------+
| id(integer) | age(varchar(20)) | name(varchar(20)) |
+-------------+------------------+-------------------+

```

There are a 100 rows of different ids, ages and names. However, since many people update the database, age and name constantly change. 

However, there are some boundaries to age and name: 

* Age has to be an integer and has to be greater than 0.
* Name has to be alphabets and not numbers.

The problem is a script to check if the change of values is within the boundaries. For example, if age = -1 or Name = 1 , these values are out of the boundaries.

Right now, there is a script that does insert \* into newtable where age < 0 and isnumeric(age) = 0 or isnumeric(name) = 0; 

The compiled new table has rows of data that have values that are out of the boundary. 

I was wondering if there is a more efficient method to do such checking in SQL. Also, i'm using `microsoft sql server`, so i was wondering if it is more efficient to use other languages such as `C#` or `python` to solve this issue.