Query Result

• agbelo

  SSC Veteran

  Points: 217

  More actions

  October 13, 2016 at 12:16 pm

  #330846

  Hello all,

  Please I want to be able to parse the result of this query to a variable using today's date. How can I write the sql code?

  EXEC sys.sp_readerrorlog 0,1,'pegasus','-'

  Thanks

  Bright

  Database Admin

• Y.B.

  SSChampion

  Points: 11642

  More actions

  October 13, 2016 at 12:34 pm

  #1906441

  sp_readerrorlog uses the extended procedure xp_readerrorlog which allows parameters for start and end dates.

  EXEC xp_readerrorlog 0, 1, 'pegasus', '-', '2016-10-13', '2016-10-14'

  ---

  SELECT quote FROM brain WHERE original = 1
  0 rows returned