Wednesday, October 26, 2011

mssql конвертация из binary в char и обратно

Exported from Notepad++
declare @bina binary(16) declare @bina1 binary(16) set @bina=newid(); select @bina select CONVERT(char(34), @bina, 1) set @bina1 = Convert(binary(16), CONVERT(char(34), @bina, 1),1) select @bina1

No comments:

Post a Comment