0x40 - in query?

• bang725

  Mr or Mrs. 500

  Points: 577

  More actions

  November 6, 2008 at 7:30 am

  #214973

  What is 0X40 in below query?

  _________________________________________

  SELECT fileid, name, filename, size, growth, status, maxsize

  FROM dbo.sysfiles WHERE (status & 0x40) <> 0

  _________________________________

• dmc-608719

  SSCarpal Tunnel

  Points: 4663

  More actions

  November 6, 2008 at 7:43 am

  #894873

  Bitwise comparison to a binary representaiton. Looks like 0X40 is a log file.

  http://msdn.microsoft.com/en-us/library/ms178009(SQL.90).aspx