how to get execution time of a sqlquery

Mar 4 2010 6:31 AM

hi iam executing this query

select * from orders where Freight=71.97 and 250 > (select count(*) from orders where employeeid=Shipvia)

aginst northwind database of a sqlserver along with the result of this query i want time taken to execute this query in one column

please help me on this

Answers (4)

Table Query

c# or sql Inner Join