How to get integer and string records from the existing table in sql server?
Purushottam Rathore
select * from // it fetch all record of table and also diff datatype aswell
Write the following query to get only integer records.
SELECT * FROM TableName WHERE ISNUMERIC(ColumnName) = 1
SELECT *
Write the following query to get non integer records.
SELECT * FROM TableName WHERE ISNUMERIC(ColumnName) <> 1