Posted by hjmaasc rolkey on 10/18/06 16:12
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 ***
Navigation:
[Reply to this message]
|