Server Feedback

[klara]

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

[Jens]

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.

[klara]

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

"Empty set (0.00 sec)"
true ?

[Hugo Kornelis]

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

[Jens]

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

HTH, jens Suessmeyer.