SQL Server | How to get only int values in sql | Sql Server Interview Part 36
Find Us On YouTube- "Subscribe Channel to watch Database related videos" / @ssunitech6890
For SQL Quiz-
• sql server : Interview Quiz | sql ser...
Find Us On FaceBook-
/ ss-unitech-187705388674384
Query--
CREATE TABLE PART36
(
ID INT,
VALUE VARCHAR(100)
)
INSERT INTO PART36 VALUES(101,'ABC'),(102,'11.14'),(103,'1'),(104,'2'),(105,'1:05'),(106,'CDC'),(107,'2019-01-01'),(108,'45')
select *
from PART36
where TRY_PARSE(value as int) is not null