Tuesday, 25 April 2017

Getting binary data from SQL db and generate update statement

CONVERT([varchar](max), binarydata, 1)


SELECT   'UPDATE table SET Field1 = Value 1 WHERE id = 14006 '+ CHAR(13)+CHAR(10) +'GO'
FROM            table WHERE id = 14006

No comments:

Post a Comment