How to verify if a record exists

How to verify if a record exists

Dear team,
Just wanted to create a custom report.
Let say I have 5 records supposed already logged: 101, 102, 103, 104, 105
And I want to know if they are still in the database (of course this is just an example because I have hundreds of records that I need to check)

SELECT wo.workorderid, wo.title from workorder wo
where wo.workorderid = 101 or
wo.workorderid = 102 or
wo.workorderid = 103 or
wo.workorderid = 104 or
wo.workorderid = 105

and I want to have something like below in return
workorderid | title | status
101 | test1 | exist
102 | test2 | exist
103 | test3 | not exist
104 | test4 | exist
105 | test5 | not exist

Hope I explained well.

Thank you


++ DATABASE is MSSQL

                  New to ADSelfService Plus?