Guid vs. UniqueIdentifier

G

Guest

Hello all

I'm stumped. I'm trying to pass in a Guid to a stroed proc that requires a unique identifier, and for the most part, it works fine. However...when I try to use this guid: 220017E1-A106-4A78-B0DA-37A199EA9C1

....the process bombs out and I get "Syntax error converting from a character string to uniqueidentifier.

I know the simple answer would be to simply go into the database and change this UID to a new ID, but I'm trying to understand why SQL won't accept the above Guid as a uniqueidentifier. .NET doesn't seem to mind it

Any ideas? Hopefully, this is blindingly obvious and I'm just not seeing it

Thanks
Chris
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top