declare @d datetime
set @d = GETDATE()
select * from dbo.spt_values
select [语句执行花费时间(毫秒)]= DATEDIFF(ms,@d,getdate())
相关文章
- 03-21get the execution time of a sql statement.
- 03-21Cause: com.baomidou.mybatisplus.core.exceptions.MybatisPlusException: The SQL execution time is too large, please optimize !
- 03-21Mybatis Error attempting to get column 'xxx' from result set. Cause: java.sql.SQLDataException: Unsupported conversion from LONG to java.time.LocalDateTime
- 03-21Error attempting to get column ‘create_time‘ from result set. Cause: java.sql.SQLFeatureNotSupported
- 03-21IDEA报Could not get JDBC Connection; nested exception is java.sql.SQLException: The server time zone value '?й???????' is unrecognized or represents more than one time zone.