Microsoft SQL Server forum - Server Feedback

Author

Server Feedback

klara

2006-01-19, 8:24 pm

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

2006-01-19, 8:24 pm

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

2006-01-19, 8:24 pm

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

"Empty set (0.00 sec)"

true ?

Hugo Kornelis

2006-01-19, 8:24 pm

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

2006-01-19, 8:24 pm

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

HTH, jens Suessmeyer.

Sponsored Links