Solved

Remove query footer in results

Posted on 2008-06-09
2
215 Views
Last Modified: 2010-04-21
I have found where to get rid of the header information for my queries but I still get

(1 row(s) affected)

for example and I don't want this.  Thanks
0
Comment
Question by:MyDanes
2 Comments
 
LVL 8

Accepted Solution

by:
sbagireddi earned 500 total points
ID: 21744959

SET NOCOUNT ON;
GO

Use the above before you execute the query.
0
 

Author Closing Comment

by:MyDanes
ID: 31465473
thank you
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Stored procedure 4 36
display data in text field from data base for updating 6 69
ISDATE() not working properly on my table? Any suggestions. 7 44
Query to return total 6 24
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
How to Install VMware Tools in Red Hat Enterprise Linux 6.4 (RHEL 6.4) Step-by-Step Tutorial
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

713 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question