• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

Trying to add two rows to existing table in SQL, but receiving conversion on Uniqueidentifier

I am trying to add two rows to an existing table in SQL Server Management Studio but receive this error:

"Conversion failed when converting from a character string to uniqueidentifier"

My assumption is that the tool I am using to load data into generates a field called _Product_ID which is unique. So I inserted some random value ({CEABDFA8-59AD-41B2-9848-898FF0EE7FDS}) to that column but still received that error.

Any thoughts?
1 Solution
Muhammad KashifDevelopment ManagerCommented:
Post your query
Jintonix415Author Commented:
insert into MyTable
([Field1], [Field2], [Field3], [Field4], [_U_1D_Product])
('Level Pay', 2344343, 60, 'Orinda', '{CEAABDFA8-59AD-41B2-9848-898FF0EE7AFS})
Scott PletcherSenior DBACommented:
"S" would not be valid in a uniqueident.

All characters must be 0-9 / A-F only.

It's actually a hexadecimal value.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now