Hexadecimal string flow, such as' 0 XFFFFFFFFFFFFFFFFF ', how to insert or update the vabinary?

CodePudding user response:

Declare @ TB table (a varbinary (Max));
Insert the @ TB values (convert (varbinary (Max), '0 XFFFFFFFFFFFFFFFFF))
Select * from @ TB

CodePudding user response:

Article has been resolved, the entire database command to @ SQL varchar type, use the exec (@ SQL), so that you can write the varchar type into varbinary,