查询sql语句执行消耗的时间

declare @sttime  datetime
set @sttime=getdate()
print @sttime
-- 要执行sql语句开始
SELECT UserSet.[Id]
      ,[LoginId]
      ,[LoginPwd]
      ,[Mail]
      ,[Tel]
      ,[SubTime]
      ,[ModificationTime]
      ,[Remark]
      ,UserStatesSet.[Name]
      ,[Address]
      ,[Image]
      ,[UserStatesId]
  FROM UserSet
  join UserStatesSet
  on UserStatesSet.id=dbo.UserSet.UserStatesId
  where UserSet.LoginId='1'
-- 要执行sql语句结束
SELECT RTRIM(CAST(DATEDIFF(MS, @sttime, GETDATE()) AS CHAR(10))) AS 'TimeTaken'