开发者

Sql query, selecting on unique identifier gives - Error converting data type varchar to uniqueidentifier

开发者 https://www.devze.com 2023-03-06 13:26 出处:网络
How do I select a column of type uniqueidentifier when I have a guid? I\'ve tried doing following: SELECT 开发者_Python百科* FROM MyTable WHERE id = \'442402e-207d-b012-4b60-005056c00123\'

How do I select a column of type uniqueidentifier when I have a guid?

I've tried doing following:

SELECT 开发者_Python百科* FROM MyTable WHERE id = '442402e-207d-b012-4b60-005056c00123'

and 

SELECT * FROM MyTable WHERE id = '{442402e-207d-b012-4b60-005056c00123}'

Both give me same error: Error converting data type varchar to uniqueidentifier.


The first query is ok, but you are missing a digit on the first part of the GUID, it should have 8 digits, not seven....something like this:

SELECT * FROM MyTable WHERE id = '71494DD6-90FB-417D-B9E2-28F34103C039'


You are missing a digit in the first section

4067876A-E3C3-4A3D-B2D3-E879474168C6 is a valid GUID
442402e-207d-b012-4b60-005056c00123 is not

0

精彩评论

暂无评论...
验证码 换一张
取 消