how to convert db table column datatype from varchar to binary(16) in sql server 2005?
i had done it earlier, and i got below error
Implicit conversion from data type varchar to binary is not allowed. Use the CONVERT function to run this query.
Add a new column, then copy/convert the data to it, then remove the old column and rename the new one.
We're a friendly, industry-focused community of 1.18 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.