mysql如何查看dbid_云数据库SQL Server版如何查看当前运行的SQL语句

执行以下SQL脚本，查看当前运行的SQL语句。

SELECT  [Spid] = session_id ,

[Database] = DB_NAME(sp.dbid) ,

[User] = nt_username ,

[Status] = er.status ,

[Wait] = wait_type ,

[Individual Query] = SUBSTRING(qt.text,

er.statement_start_offset / 2,

( CASE WHEN er.statement_end_offset = -1

THEN LEN(CONVERT(NVARCHAR(MAX), qt.text))

* 2

ELSE er.statement_end_offset

END - er.statement_start_offset )

/ 2) ,

[Parent Query] = qt.text ,

Program = program_name ,

hostname ,

nt_domain ,

start_time

FROM    sys.dm_exec_requests er

INNER JOIN sys.sysprocesses sp ON er.session_id = sp.spid

CROSS APPLY sys.dm_exec_sql_text(er.sql_handle) AS qt

WHERE   session_id > 50

AND session_id NOT IN ( @@SPID )