一段输出代码本身的SQL代码

 百家乐-数据     |      2020-01-10 18:51
declare @text nvarchar(max);with tbas(select blocking_session_id,session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests aCROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)),tb1 as(select a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8 as 'memory_usage(KB)',total_scheduled_time,reads,writes,logical_reads from tb a inner join master.sys.dm_exec_sessions bon a.session_id=b.session_id)select @text=text from tb1 a inner join master.sys.dm_exec_connections b on a.session_id=b.session_id print @text/*declare @text nvarchar(max);with tbas(select blocking_session_id,session_id,db_name(database_id) as dbname,text from master.sys.dm_exec_requests aCROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)),tb1 as(select a.*,login_time,program_name,client_interface_name,login_name,cpu_time,memory_usage*8 as 'memory_usage(KB)',total_scheduled_time,reads,writes,logical_reads from tb a inner join master.sys.dm_exec_sessions bon a.session_id=b.session_id)select @text=text from tb1 a inner join master.sys.dm_exec_connections b on a.session_id=b.session_id print @text*/

还可以短一点:

declare @text nvarchar(max);select @text=text from master.sys.dm_exec_requests aCROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)print @text/*declare @text nvarchar(max);select @text=text from master.sys.dm_exec_requests aCROSS APPLY master.sys.dm_exec_sql_text(a.sql_handle)print @text*/

<