February 23, 2012 at 2:46 pm
I am trying to mask the some of the columns in table1 . Throwing below error. Any body had this issue? Please advise.
UPDATE Table1
SET LoginEmail = 'XXXX@XXXX.COM',
LoginFirstName = 'XXXFirstName'
,LoginMiddleName = 'XXXMiddleName'
,LoginLastName = 'XXXLastName'
,LoginPassword = 'XXXXXXXXXX'
,LoginSkey = 'XXXXX'
Error:
Msg 257, Level 16, State 3, Line 1
Implicit conversion from data type varchar to varbinary(max) is not allowed. Use the CONVERT function to run this query.
February 23, 2012 at 3:00 pm
Either LoginPassword or LoginSKey (or other cols) is a VARBINARY(MAX) data-type. you can not convert 'xxxx' implicitly.. You have to wrap like this CAST( 'XXXX' AS varbinary(max))
or CONVERT(VARBINARY(MAX) ,'XXXX')
February 23, 2012 at 8:58 pm
Thanks.
How can I mask uniqueidentifier datatype column?
error:
Msg 8169, Level 16, State 2, Line 2
Conversion failed when converting from a character string to uniqueidentifier.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply