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
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