----执行效率检测---declare @begin_date datetime declare @end_date datetime select @begin_date = getdate() ---中间是你要执行的程序select @end_date = getdate() select datediff(ms,@begin_date,@end_date) as '用时/毫秒'