Diachok's IT blog
IT Sector Life
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment