Posted by Hugo Kornelis on 01/19/06 22:53

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

[Back to original message]