Post reply

data available? not available??

  • March 11, 2008 at 7:48 am

    #183892

    I recently faced a problem with data being there and not being there.

    Let me explain. A particular row didnt have any values for a particular field when i looked into the the table by returning all rows from enterprise manager. At the same time, a select query for that particular field in that row revealed it HAD lots of values in there.

    Any clues whether the data is there? not there? which one is right? why does this happen?

    Thanks,

    Learner.

  • March 11, 2008 at 11:49 am

    #788195

    Looks like a case of dirty reads. Is the query executed with set transaction isolation level read uncommitted ?

    SQL DBA.

  • March 11, 2008 at 3:10 pm

    #788292

    Not sure what youre trying to say.

    Thanks,

    Learner

  • March 11, 2008 at 4:08 pm

    #788309

    Do you have any hex 0'x in the beginning of the data? If theres x00, the data wont get displayed correctly. This can be verified using a simple convert.

    select convert(binary,columnname) from table

    --------------------------------------------------------------------------------------
    Save our world, its all we have! A must watch video Pale Blue Dot[/url]

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply