Simple check for SELECT query empty result

Question

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

User · Answer

SELECT COUNT 1  FROM service s WHERE s service id

User · Answer

In my sql use information function   select FOUND ROWS      it will return the no  of rows returned by select query

User · Answer

SELECT   FROM service s WHERE s service id      BEGIN    print  no data  END

User · Answer

Use   ROWCOUNT   SELECT   FROM service s WHERE s service id       IF   ROWCOUNT  gt  0     -- do stuff here        According to SQL Server Books Online      Returns the number of rows affected by   the last statement  If the number of   rows is more than 2 billion  use   ROWCOUNT BIG

User · Answer

SELECT count    as count FROM service s WHERE s service id        test if count    0    More baroquely   select case when  SELECT count    as count FROM service s WHERE s service id        0     then  No rows  bro   else  You got data   end as stupid message

User · Answer

SELECT   FROM service s WHERE s service id      IF   rowcount   0 begin select  no data  end

User · Answer

You can do it in a number of ways   IF EXISTS select   from       begin  -- select   from       end else  -- do something    Or you can use IF NOT EXISTS     ROW COUNT like   select   from      IF   ROW COUNT gt 0  begin -- do something end

User · Answer

try   SELECT   FROM service s WHERE s service id       IF   ROWCOUNT 0 BEGIN     PRINT  no rows   END

User · Answer

well there is a way to do it a little more code but really effective   x000D   x000D   sql    SELECT   FROM messages      your query x000D   result  connvar- gt query  sql         connvar is the connection variable x000D   flag 0  x000D       while  rows2 mysqli fetch assoc  result2   x000D         flag     x000D       x000D  if  flag  0  no rows selected   x000D  else  x000D  echo  flag      rows are selected  x000D    x000D   x000D   x000D

User · Answer

I agree with Ed B  You should use EXISTS method but a more efficient way to do this is   IF EXISTS SELECT 1 FROM service s WHERE s service id      BEGIN    --DO STUFF HERE  END   HTH

User · Answer

IF EXISTS SELECT   FROM service s WHERE s service id       BEGIN    --DO STUFF HERE   END

User · Answer

To summarize the below posts a bit   If all you care about is if at least one matching row is in the DB then use exists as it is the most efficient way of checking this  it will return true as soon as it finds at least one matching row whereas count  etc will find all matching rows   If you actually need to use the data for processing or if the query has side effects  or if you need to know the actual total number of rows then checking the ROWCOUNT or count is probably the best way on hand

User · Answer

SELECT count    as CountThis       Then you can compare it as string like so   IF CHECKROW RS  CountThis    0  THEN       CHECKROW RS is an object

[sql] Simple check for SELECT query empty result

Examples related to sql

Examples related to sql-server

Examples related to database