Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

duration of a query

Status
Not open for further replies.

ScanX

Programmer
Oct 13, 2003
26
BE
Hi

I'm using Interactive SQL and I would like to know if there was a function that could return the execution time (duration) of the last query executed ?

Thanx in advance
 
Hi

Try using the various "SET statistics" commands to ON like:


SET STATISTICS TIME ON
SET STATISTICS IO ON



-=-=-=-=-=-=-=-=-
For ease of reading, any posted CODE should be wrapped by [ignore][COLOR]
and
Code:
[/ignore] tags.

Ex:
Code:
SELECT 1 from sysobjects

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top