Wednesday, March 7, 2012

How *NOT* to display header column

Hi,

1. This is what SET NOCOUNT ON does:

-- SET NOCOUNT to ON and no longer display the count message.
SET NOCOUNT ON
GO
SELECT au_lname
FROM authors
GO

2. Now, is it possible and what is the statement to use if I don't want to display
the header column? au_lname. Thanks.From the Sql Bible:

SET NOCOUNT {ON | OFF}
SQL Server usually returns a message indicating how many rows were affected by any given statement. Issuing this command would stop this message.

HH

NeuralC|||Hi NeuralC

I already knew question 1 :-D . What is I'm looking for is question 2. Thanks.|||Hi,

Graphically, I got it for question 2 using Tools, Option ... from QA.

Still, statement-wise, what is it? Thanks.|||What client are you using...that's what renders the hender not SQL itself...unless you're talking about renaming the fields

No comments:

Post a Comment