如何计算sql语句执行时间的时间

[machao299]

select * from tableName where userName="xxxx" and userPwd="xxxx"
请问怎么计算执行 这句 sql 语句用了多长时间啊？？

[wzy_love_sly]

set statistics time on

[wzy_love_sly]

要想查出来

declare @starttime datetime
set @starttime=getdate()
select * from tb -- 执行语句
select datediff(ss,@starttime,getdate())

[you_tube]

declare @startime datetime
declare @endtime datetime

set @startime = Getdate()
select * from tb -- 执行语句
set @endtime datetime
print @endtime - @startime

[you_tube]

declare @startime datetime
declare @endtime datetime

set @startime = Getdate()
select * from tb -- 执行语句
set @endtime = Getdate()
print @endtime - @startime

[dollyxz]

declare @startime datetime
declare @endtime datetime

set @startime = Getdate()
select * from tb -- 执行语句
set @endtime = Getdate()
select convert(varchar,datepart(s,@endtime-@startime))+':'+convert(varchar,datepart(ms,@endtime-@startime)) as '总时间'

[biweilun]

declare @startime datetime 
declare @endtime  datetime 

set @startime = Getdate() 
select * from tb -- 执行语句 
set @endtime datetime 
print @endtime - @startime