Accepted answer
-
-- -- 706 Reputation points
2021-07-14T03:56:56.84+00:00 Hi
This works for me.
IF EXISTS (SELECT 1 FROM OPENDATASOURCE('SQLNCLI11', 'SERVER=...;DATABASE=MyDB;UID=...;PWD=...;').MyDB.dbo.Staff WHERE ID = @ID) PRINT 'Found!' ELSE PRINT 'Not Found!'
Regards
0 additional answers
Sort by: Most helpful