查看最近的增删改查操作

select userid,COUNT(userid) from PhoneOrder 
group by UserID 
order by UserID 


select  s2.dbid ,
        s1.sql_handle ,
        ( select top 1  substring(s2.text, statement_start_offset / 2 + 1,
                                  ( ( case when statement_end_offset = -1 then ( len(convert(nvarchar(max), s2.text)) * 2 )
                                           else statement_end_offset
                                      end ) - statement_start_offset ) / 2 + 1)
        ) as sql_statement
from    sys.dm_exec_query_stats as s1
        CROSS APPLY sys.dm_exec_sql_text(sql_handle) as s2
where   patindex('%Insert%', s2.text) > 0
        or patindex('%update%', s2.text) > 0
        or patindex('%delete%', s2.text) > 0