Help with CONVERT
-
When attempting to update a recordset, I get an error saying: Msg 257, Level 16, State 3, Line 1 Implicit conversion from data type varchar to binary is not allowed. Use the CONVERT function to run this query. I've Googled it but can't find a concrete answer how to use the convert function to do this. My statement is something like: UPDATE USERS SET PASSWORD ='0x98CA89CFB23D213D3A12C54B', HASH ='0x134523450' WHERE ID='1';
-
When attempting to update a recordset, I get an error saying: Msg 257, Level 16, State 3, Line 1 Implicit conversion from data type varchar to binary is not allowed. Use the CONVERT function to run this query. I've Googled it but can't find a concrete answer how to use the convert function to do this. My statement is something like: UPDATE USERS SET PASSWORD ='0x98CA89CFB23D213D3A12C54B', HASH ='0x134523450' WHERE ID='1';
You don't need to enclose binary data within single quotes. UPDATE USERS SET PASSWORD =0x98CA89CFB23D213D3A12C54B, HASH =0x134523450 WHERE ID='1';
-
You don't need to enclose binary data within single quotes. UPDATE USERS SET PASSWORD =0x98CA89CFB23D213D3A12C54B, HASH =0x134523450 WHERE ID='1';