SQL Server | How to get only int values in sql | Sql Server Interview Part 36

Published: 15 November 2019
on channel: SS UNITECH

2,953

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

On this page of the site you can watch the video online SQL Server | How to get only int values in sql | Sql Server Interview Part 36 with a duration of hours minute second in good quality, which was uploaded by the user SS UNITECH 15 November 2019, share the link with friends and acquaintances, this video has already been watched 2,953 times on youtube and it was liked by 58 viewers. Enjoy your viewing!