Записи по mssql,oracle,windows и linux

Have a Question?

If you have any question you can ask below or enter what you are looking for!

xml в текст

SELECT [dd hh:mm:ss.mss]
      ,CAST(sql_text AS nvarchar(max))
  FROM [dbo].[www_AxaptaInfoBoardWhoIsActive]
CAST([sql_text] AS nvarchar(max)) LIKE ('%UPDATE %') and
          CAST([sql_text] AS nvarchar(max)) LIKE ('%InventTable%') AND
--sql_text  LIKE ('%InventTable%') AND
 datepart(YEAR,start_time) BETWEEN 2015 AND 2015 and
                    datepart(month,start_time) BETWEEN 11 AND 11 and
                    datepart(day,start_time) BETWEEN 17 AND 18  AND
          --DATEPART(hour,start_time) BETWEEN 13 AND 23 AND
          database_name IN ('ax_molniya') 
ORDER BY start_time


Leave a Reply

Your email address will not be published. Required fields are marked *

You can use these HTML tags and attributes <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>