34,837
社区成员




SELECT CONVERT(binary(4), '0x4E616D65',1) AS 'Style 1, character to binary'
SELECT CONVERT(binary(4), '0x4E616D65',1) AS 'Style 1, character to binary'
select @@version
0x30783445
Microsoft SQL Server 2005 - 9.00.5000.00 (Intel X86) Dec 10 2010 10:56:29
SELECT CONVERT(binary(4), '0x4E616D65',1) AS 'Style 1, character to binary'
select @@version
0x4E616D65
Microsoft SQL Server 2012 - 11.0.2218.0 (X64)
Sorry,貌似是05和2012的结果有出入.SELECT CONVERT(binary(4), '0x4E616D65',1) AS 'Style 1, character to binary'
SELECT @@version
/*
Style 1, character to binary
----------------------------
0x4E616D65
(1 行受影响)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2008 R2 (SP1) - 10.50.2500.0 (X64)
Jun 17 2011 00:54:03
Copyright (c) Microsoft Corporation
Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1, v.721)
(1 行受影响)
*/
SELECT CONVERT(binary(4), '0x4E616D65',1) AS 'Style 1, character to binary'
SELECT @@version
/*
Style 1, character to binary
----------------------------
0x4E616D65
(1 行受影响)
----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
Feb 10 2012 19:39:15
Copyright (c) Microsoft Corporation
Enterprise Edition: Core-based Licensing (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
(1 行受影响)
*/