How to separate Integers from String using T-SQL

Here we can see different methods to separate Integers and String data types from a string variable.

SET NOCOUNT ON