Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • 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?
0
Jintonix415
Asked:
Jintonix415
1 Solution
 
Muhammad KashifDevelopment ManagerCommented:
Post your query
0
 
Jintonix415Author Commented:
insert into MyTable
([Field1], [Field2], [Field3], [Field4], [_U_1D_Product])
Values
('Level Pay', 2344343, 60, 'Orinda', '{CEAABDFA8-59AD-41B2-9848-898FF0EE7AFS})
0
 
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.
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

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