I resolved the problem by: SELECT CONVERT(VARCHAR(max), GGUID ) FROM dbo.xxxxx WHERE KEYWORD LIKE 'Avast'
Now I get the right guid .
Thanx for reading and / or replieing
Cheers
I'll try to explain what I happens: in the table on the server is a primary key declared gguid binary(16) From this table I need to get some information and then alter another table linked to this table using the primary key from the first. When I select one row using a keyword and reading the...
Thank you for your reply. I tried to do so but when I want to update a record with the returned guid it will fail because the returned guid is not existing in the table
Sorry i wasn't clear enough. The field I'm trying to read is a guid. When I read the field tape in vb (like idx = reader.GetDataTypeName(0)) it returns binary. Then when I read the contents of that field like (retval = reader.GetSqlBinary(0).ToSqlGuid) the returned value diffiers from the value...
Hello there,
I've to get a primary key from ms sql database table. Unfortunate th keys are declared as binary length 16. My query recognizes the field as system.binary and I don't know how to use this field further to insert data or modify another table which is linked using this key. Does...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.