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