Searching By UniqueIdentifier

• jarid.lawson

  SSCrazy

  Points: 2953

  More actions

  October 8, 2012 at 10:24 am

  #282807

  So I have a table with several UniqueIdentifier columns. I am exploring the database to get a handle on my new position, and honestly have not used the UniqueIdentifier data type much before.

  Just out of curiosity I ran

  Select Count(*) As RecordCount

  ,EventID

  From dbo.Events

  Group By EventID

  The first record in the record set is:

  RecordCountEventID

  3631AB0164-6BC9-448D-BC3E-53FEA210365E

  Looking at the SAME TABLE I run the following

  Select *

  From dbo.Events

  Where EventID = '31AB0164-6BC9-448D-BC3E-53FEA210365E'

  --or--

  Select *

  From dbo.Events

  Where Cast(EventID As nVarchar(36)) = '31AB0164-6BC9-448D-BC3E-53FEA210365E'

  --or--

  Select *

  From dbo.Events

  Where Cast(EventID As nVarchar(Max)) = '31AB0164-6BC9-448D-BC3E-53FEA210365E'

  I tried a few other permutations of the Cast / Convert method, but in every case I do not return any records...yet the count says there should be 36 records returned.

  What am I missing?

  [font="Arial"]“Any fool can know. The point is to understand.”
  - Albert Einstein

  "DOH!"
  - Homer Simpson[/font]

• Eugene Elutin

  SSC Guru

  Points: 59322

  More actions

  October 8, 2012 at 10:26 am

  #1546833

  Try:

  Select *

  From dbo.Events

  Where EventID = '{31AB0164-6BC9-448D-BC3E-53FEA210365E}'

  _____________________________________________
  "The only true wisdom is in knowing you know nothing"
  "O skol'ko nam otkrytiy chudnyh prevnosit microsofta duh!":-D
  (So many miracle inventions provided by MS to us...)

  How to post your question to get the best and quick help[/url]