Solved

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

Posted on 2012-03-22
3
189 Views
Last Modified: 2012-03-22
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
Comment
Question by:Jintonix415
3 Comments
 
LVL 11

Expert Comment

by:Muhammad Kashif
ID: 37754284
Post your query
0
 

Author Comment

by:Jintonix415
ID: 37754587
insert into MyTable
([Field1], [Field2], [Field3], [Field4], [_U_1D_Product])
Values
('Level Pay', 2344343, 60, 'Orinda', '{CEAABDFA8-59AD-41B2-9848-898FF0EE7AFS})
0
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 total points
ID: 37754635
"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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

860 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question