How to get code Execution Time

Posted Date: 04 May 2008 Resource Type: Code Snippets Category: SQL

Posted By: Vijaya Member Level: Diamond
Rating:

Points: 10

The following code snippet helps to get code execution time
DECLARE @start DATETIME, @End DATETIME
SET @start = CURRENT_TIMESTAMP

DECLARE @i INT
SET @i = 0
WHILE @i < 24000
BEGIN
SET @i = @i + 1
END
SET @End = CURRENT_TIMESTAMP
SELECT DATEDIFF(MS, @start, @End)

Responses

Author: santhoshkumar 09 May 2008

Member Level: Gold Points : 2

I will check and see what will hapen

Author: Jaya Kumar 15 May 2008

Member Level: Gold Points : 2

Use also Use Like this

SELECT GetDate()

//Your Query Comes Here

SELECT GetDate()

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: How to Copy Data from one table to another
	Previous Resource: Find Difference between two dates in T-SQL
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

budget conference call