hi
is it possible in a query dont show the result rows??
i wanna write

select *
from table

set @num=@@rowcount

and i dont wanna see all the rows affected
thanks
Carlo

How about

SELECT @num = COUNT(*) FROM table


Show quoteHide quote

thanks

another stupid question:
can i dont write the message like :
(7 row(s) affected)

?????
thanks
carlo


Show quoteHide quote

SET NOCOUNT ON

SET @num =
(SELECT COUNT(*)
  FROM table)

Note that @@ROWCOUNT will now be 1regardless of the value returned in
@num.

Carlo,

What for is @num?. You can do the following:

select @num = count(*) from t1 where ...
....

or

if exists(select * from t1 where ...)
   ...


AMB


Show quoteHide quote

Carlo wrote:
Row Affected shows up when you have not set SET NOCOUNT ON. You've
already received the answer if what you wanted was to not see the rows
themselves, but when reading your post, it's not clear what you want.

If you want to see all the rows, then define the select statement with
only the columns you need. Assuming you're fetching them on the client,
you can count the rows there.

If all you need is the rowcount for the select statement, then read the
other posts about assigning the count to a local variable.

You should always have SET NOCOUNT ON as the first statement of each
stored procedure and as the first SQL call from an application that uses
embedded SQL. That will suppress the "x Row(s) Affected" message.

SQLDataAdapter.FillSchema() hangs with select on view
Simplifying CHECK constraint
disagreement over PK "naming convention"
SP plan different from batch
how to rename a temp table