Server Feedback

I haven't touched MSSS in a looong time
When a SELECT returns say 3 rows what does the feedback say ?
(eg Oracle/sqlplus says "3 rows selected")
What if "no data found", what is the feedback ?

thanks

If 3 rows are returned ( / affected) sql server states (wheter you are
doing a (select / insert / update / delete)

(3 row(s) affected)

No rows "affected" ? --> (0 row(s) affected)

You can switch that off setting the SET NOCOUNT ON option.

HTH, Jens Suessmeyer.

thanks, someone told me when no data found, it shows this :

"Empty set (0.00 sec)"


true ?

On 19 Jan 2006 12:21:17 -0800, klara wrote:

>thanks, someone told me when no data found, it shows this :
>
>"Empty set (0.00 sec)"
>
>
>true ?

Hi Klara,

For SQL Server? No.


SET NOCOUNT OFF
USE pubs
SELECT au_fname
FROM   authors
WHERE  au_id = '998-72-3568'
go


au_fname
--------------------

(0 row(s) affected)



--
Hugo Kornelis, SQL Server MVP

Huh, didn=B4t see that, perhaps you ask him where he saw that. Maybe
this as some custom front end application.

HTH, jens Suessmeyer.