purpose of OUTPUT keyword in sql server

hello sirs
purpose OUTPUT keyword with examplessurya (suryaitha@.gmail.com) writes:
> hello sirs
> purpose OUTPUT keyword with examples

You use OUTPUT to specify that a parameter is an output parameter:

CREATE PROCEDURE getordercount @.custid int, @.cnt OUTPUT AS
SELECT @.cnt = COUNT(*) FROM orders WHERE custid = @.custid

What is special with T-SQL, is that you need to specify OUTPUT also when you
call the procedure:

EXEC getordercount @.custid, @.cnt OUTPUT

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx|||Erland,

you said right about OUTPUT parameters...
but what about the OUTPUT clause of
DELETE, INSERT and UPDATE statements
in SQL Server 2005?

surya, for more details about the OUTPUT clause see the following link:
http://msdn2.microsoft.com/en-us/library/ms177564.aspx

--
Andrey Odegov
avodeGOV@.yandex.ru
(remove GOV to respond)|||avode (avode_spam@.yahoo.com) writes:
> you said right about OUTPUT parameters...
> but what about the OUTPUT clause of
> DELETE, INSERT and UPDATE statements
> in SQL Server 2005?

Sorry! There's so much new stuff, that I tend to forget some of it.
The OUTPUT clause in one of the more obscure items.

> surya, for more details about the OUTPUT clause see the following link:
> http://msdn2.microsoft.com/en-us/library/ms177564.aspx

...and if it was in that context you asked about OUTPUT, surya, please
tell us if you want more clarifcation.

Thanks for posting the link Andrey.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

PSSDiag Utility Questions

Would anyone can told me following about PSSDiag ?

1. The Performance Monitor output is default set to output as .BLG file, would it be other format like CSV or TXT ?

2. For SQL Trace log gathering location, even those we set to drive other than C:\ , it still need some spaces for temporary storage in C:\ under setting of TEMP and TMP path, so is PSSDIAG still need temporary spaces in dirve C:\

3. Does this utility also support monitor on SQL 2005 server ? Pls

Many Thanks First.

1. You cannot change the default output for PERFMON.

2. Yes it access the TEMP directory to perform few computations.

3. http://www.microsoft.com/downloads/details.aspx?familyid=5564386A-28C2-4483-8293-76FFF67B9EB3&displaylang=en refers :

System Requirements

Supported Operating Systems: Windows 2000; Windows NT; Windows Server 2003; Windows XP|||

how about if my server cannot install MSXML 4.0 SP2 ? Can I use alternative method that use ini instead of xml configuration file ?

Also, can I find some example of the ini file format somewhere as I can't find any in the web especially those with some calling custom utility function as I want to start the Performance Monitor myself which can stored as csv format?

Many Thanks.

|||

Have you tested the installation of MSXML SP in thsi case?|||

Satya SKJ wrote:

Have you tested the installation of MSXML SP in thsi case?

yes. if using MSXML4.0SP2, I can start the PSSDIAG but my production server not allow me to apply them. If so, need to go through a complex QC cycle. So, only test on testing server but cannot apply them into Production Server.

|||

Then I believe we are out of option, either you can open a case with Microsoft Support to have desired facility or follow whatever is available.

PSSDiag Utility Questions

Would anyone can told me following about PSSDiag ?

1. The Performance Monitor output is default set to output as .BLG file, would it be other format like CSV or TXT ?

2. For SQL Trace log gathering location, even those we set to drive other than C:\ , it still need some spaces for temporary storage in C:\ under setting of TEMP and TMP path, so is PSSDIAG still need temporary spaces in dirve C:\

3. Does this utility also support monitor on SQL 2005 server ? Pls

Many Thanks First.

1. You cannot change the default output for PERFMON.

2. Yes it access the TEMP directory to perform few computations.

3. http://www.microsoft.com/downloads/details.aspx?familyid=5564386A-28C2-4483-8293-76FFF67B9EB3&displaylang=en refers :

System Requirements

Supported Operating Systems: Windows 2000; Windows NT; Windows Server 2003; Windows XP|||

how about if my server cannot install MSXML 4.0 SP2 ? Can I use alternative method that use ini instead of xml configuration file ?

Also, can I find some example of the ini file format somewhere as I can't find any in the web especially those with some calling custom utility function as I want to start the Performance Monitor myself which can stored as csv format?

Many Thanks.

|||

Have you tested the installation of MSXML SP in thsi case?|||

Satya SKJ wrote:

Have you tested the installation of MSXML SP in thsi case?

yes. if using MSXML4.0SP2, I can start the PSSDIAG but my production server not allow me to apply them. If so, need to go through a complex QC cycle. So, only test on testing server but cannot apply them into Production Server.

|||

Then I believe we are out of option, either you can open a case with Microsoft Support to have desired facility or follow whatever is available.