C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




How to find Query Execution Time


Posted Date: 03 May 2007      Total Responses: 1
Posted By: Balamurugan Ranganathan       Member Level: Silver     Points: 2


How to find Execution Time of a SQL QUERY while executing the query with SqlCommand(cmd) in C#.NET



Responses
Author: sankar    04 May 2007Member Level: SilverRating:     Points: 2
just try like this..
set @starttime=getDatetime()
---
your qry statement
---
set @endtime getDatetime()

set @qryexetime= datediff(@starttime,@endtime )

print @qryexetime

sankar


Post Reply
You must Sign In to post a response.
Next : Case query in Sql Server 2005
Previous : How To Find SQL QUERY EXECUTION TIME - Very urgent Please Help
Return to Discussion Forum
Post New Message
Category: SQL Server

Related Messages


dotNet Slackers   BizTalk Adaptors    Web Design

doors in nj

Contact Us    Privacy Policy    Terms Of Use