Home/ Questions/Fixing the error: conversion failed when converting from a character string to uniqueidentifier
Next
Answered
Nathan Jean
  • 19
Asked: 2022-05-12T11:31:08+00:00 In:

Fixing the error: conversion failed when converting from a character string to uniqueidentifier

  • 19

. Advertisement .

..3..

. Advertisement .

..4..

I get the error message:

Conversion failed when converting from a character string to uniqueidentifier.

Has anyone ever faced this problem? How to troubleshoot the “ conversion failed when converting from a character string to uniqueidentifier” But the problem is appearing when I try to operate the following program

insert into [db].[dbo].[table] (myid,friendid,time1,time2) values
  ( CONVERT(uniqueidentifier,'0C6A36BA-10E4-438F-BA86-0D5B68A2BB15'),
  CONVERT(uniqueidentifier,'DF215E10-8BD4-4401-B2DC-99BB03135F2E'),
 '2014-01-05 02:04:41.953','2014-01-05 12:04:41.953')
id uniqueidentifier,
 myid uniqueidentifier,
 friendid uniqueidentifier,
 time1 datetime nullable,
 time2 datetime nullable
conversion failed
Share

2 Answers

  1. Best Answer
    Expert

    The cause: The ID column wasn’t getting any value.

    Solution: You must check unique identifier column and that particular field must be given a different value. If you give the same value, it will not work. It enforces uniqueness of the key. Below is the code:

    Insert into production.product 
(Name,ProductNumber,MakeFlag,FinishedGoodsFlag,Color,SafetyStockLevel,ReorderPoint,StandardCost,ListPrice,Size 
,SizeUnitMeasureCode,WeightUnitMeasureCode,Weight,DaysToManufacture, 
    ProductLine, 
    Class, 
    Style , 
    ProductSubcategoryID 
    ,ProductModelID 
    ,SellStartDate
,SellEndDate 
    ,DiscontinuedDate 
    ,rowguid 
    ,ModifiedDate 
  ) 
  values ('LL lemon' ,'BC-1234',0,0,'blue',400,960,0.00,100.00,Null,Null,Null,null,1,null,null,null,null,null,'1998-06-01 00:00:00.000',null,null,'C4244F0C-ABCE-451B-A895-83C0E6D1F468','2004-03-11 10:01:36.827')
    • 14

  2. MSDN Documentation Here

    The following code can be used to convert a string into a unique identifier to add context to M.Ali’s Answer 

     SELECT CONVERT(uniqueidentifier,'DF215E10-8BD4-4401-B2DC-99BB03135F2E')

    If this doesn’t work, make sure that you have entered the GUID

    • 7

Leave an answer

You must login to add an answer.

Need An Account,