Jintonix415
asked on
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- 898FF0EE7F DS}) to that column but still received that error.
Any thoughts?
"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-
Any thoughts?
Post your query
ASKER
insert into MyTable
([Field1], [Field2], [Field3], [Field4], [_U_1D_Product])
Values
('Level Pay', 2344343, 60, 'Orinda', '{CEAABDFA8-59AD-41B2-9848 -898FF0EE7 AFS})
([Field1], [Field2], [Field3], [Field4], [_U_1D_Product])
Values
('Level Pay', 2344343, 60, 'Orinda', '{CEAABDFA8-59AD-41B2-9848
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.