Simple check for SELECT query empty result
Posted
by den-javamaniac
on Stack Overflow
See other posts from Stack Overflow
or by den-javamaniac
Published on 2010-05-21T19:30:23Z
Indexed on
2010/05/21
19:40 UTC
Read the original article
Hit count: 165
Hi. Can anyone point out how to check if a select query returns non empty result set?
For example I have next query:
SELECT * FROM service s WHERE s.service_id = ?;
Should I do something like next:
ISNULL(SELECT * FROM service s WHERE s.service_id = ?)
to test if result set is not empty?
© Stack Overflow or respective owner
