Posted by Dan Guzman on 10/19/06 12:38

> taked error is "Message 8169 string to uniqueidentifier error"
> why?

I suspect your KeyField column is a string type instead of uniqueidentifier
and you have existing data in the table that can't be converted to
uniqueidentifier for the WHERE clause comparison. If this is not your
problem, please post the CREATE TABLE DDL for your table.


--
Hope this helps.

Dan Guzman
SQL Server MVP

"hjmaasc rolkey" <hjmaasc@163.com> wrote in message
news:45365250$0$10308$815e3792@news.qwest.net...
> declare @sd1 uniqueidentifier,
> @sd2 uniqueidentifier
> set @sd1='984AB9D7-3E8F-483E-9346-2DE900224594'
> set @sd2='B20937DF-B1C6-41D4-B7CD-511BEB72C1E9'
>
> Here is not errro, but
>
> declare @sd1 uniqueidentifier,
> @sd2 uniqueidentifier
> set @sd1='984AB9D7-3E8F-483E-9346-2DE900224594'
> set @sd2='B20937DF-B1C6-41D4-B7CD-511BEB72C1E9'
> UPDATE TableName SET Value=@sd1
> WHERE KeyField=@sd2
>
> taked error is "Message 8169 string to uniqueidentifier error"
> why?
>
> *** Sent via Developersdex http://www.developersdex.com ***

• Next in forum: No Local instance with SQLServer2005 Dev. Ed.
• Prev in forum: Re: unable to run mysql server 5 on windows
• Thread view: Re: Update a uniqueidentifier from a string!!!

[Reply to this message]