473,698 Members | 2,153 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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

Jan 19 '06 #1
4 1167
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.

Jan 19 '06 #2
thanks, someone told me when no data found, it shows this :

"Empty set (0.00 sec)"
true ?

Jan 19 '06 #3
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
Jan 19 '06 #4
Huh, didn´t see that, perhaps you ask him where he saw that. Maybe
this as some custom front end application.

HTH, jens Suessmeyer.

Jan 19 '06 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

21
3372
by: Nancy | last post by:
Hi, Guys, Is there any other way to use python or mod_python writing a web page? I mean, not use "form.py/email", no SMTP server. <form action="form.py/email" method="POST"> ... Thanks a lot. Nancy W
48
3719
by: ik | last post by:
ERROR after uninstalling SQL Server 2005 Express I get this message, SQLDMO has not been registered. Please re-run your setupand contact your system administrator. GREAT!!! ReInstalled SQL SERVER 2000 after playing around with SQL Server 2005...
28
3392
by: prunoki | last post by:
Hello, I am an SQL server newbie. Our company has a massive application written in PL/SQL. I need to port parts of it to SQL Server. - Which SQL server version should I choose, to have a reasonable chance of porting? - Could you recommend any best practices, tools? I use Toad for SQL development on Oracle, I am looking for something similar for SQL
0
367
by: Jonas Hei | last post by:
I need to develop a scalable server which has to receive and send UDP messages. It is required to process hundreds of messages (coming from different remote computers) per second (possibly even thousands) and of course I would like to make it as performant and scalable as I can. The idea is that remote computers send data to this server. The remote computers will send data from any random port to port 28901 of my server. My server then...
0
1300
by: mortb | last post by:
My problem is with a XML file that resides on my windows 2003 web server. I have this user control which I include on every page in my applicaiton. The control makes it possible for the users to leave feedback when using the page. The feedback is written to a XML file which I have put in a folder "C:/Save/". I've set the access rights on this folder so that the "IUSR_MachineName" has full rights on this folder and it's children. The...
14
12716
by: Lorenzo | last post by:
Hello, I have a web application with a virtual directory in it. With 'virtual directory' i mean a folder whose physical path is different from the physical path of the application, but in which Web Sharing is active. For example: my application is in "C:\Inetpub\wwwroot\MyApp", the Virtual folder is in "C:\VirtualFolder", and IIS sees it as if it were in "C:\Inetpub\wwwroot\MyApp\VirtualFolder".
10
4780
by: Henrik Dahl | last post by:
Hello! I have an xml schema which has a date typed attribute. I have used xsd.exe to create a class library for XmlSerializer. The result of XmlSerializer.Serialize(...) should be passed as the value for the parameter of an SqlCommand for inserting the xml document in a column of a table where the column is typed to be of the same xml schema. This all sounds simple, but SQL Server REQUIRES the timezone to be specified for date values....
5
23644
by: deepakNagpal | last post by:
hi friends i am trying to create a contact feedback form. but when i am running the code it showing some warning: Please if anyone can help me. PHP Warning: mail() : SMTP server response: 501 5.5.4 Invalid Address in C:\Inetpub\wwwroot\mySite\send_simpleform.php on line 20 my html code is:
3
2616
by: whelme | last post by:
Hi, i am trying to make a comments page for a website but when i upload it to a free hosting account and try to test the page i keep getting Server.CreateObject Failed is this problem because the servers don't support the command or because i have coded it wrong here is my code: <%
1
2558
by: evoloyeu | last post by:
hi buddy,the error is: type Exception report message description The server encountered an internal error () that prevented it from fulfilling this request. exception org.apache.jasper.JasperException: java.lang.NullPointerException
0
8603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9157
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9026
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8893
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
7723
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
4619
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3045
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2328
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2001
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.