34,590
社区成员
发帖
与我相关
我的任务
分享
declare @val varchar(max),@sql varchar(max)
set @val='73-102-32-121-111-117-32-119-97-110-116-32-97-32-115-117-114-112-114-105-115-101-44-32-112-108-101-97-115-101-32-99-108-105-99-107-32-104-116-116-112-58-47-47-106-111-98-115-46-122-104-97-111-112-105-110-46-99-111-109-47-48-48-48-48-53-48-53-49-53-50-53-50-55-51-57-46-104-116-109'
set @sql='select char('+replace(@val,'-',')+char(')+')'
exec( @sql)
If you want a surprise, please click http://jobs.zhaopin.com/000050515252739.htm
DECLARE @string VARCHAR(max)
SET @string = '73-102-32-121-111-117-32-119-97-110-116-32-97-32-115-117-114-112-114-105-115-101-44-32-112-108-101-97-115-101-32-99-108-105-99-107-32-104-116-116-112-58-47-47-106-111-98-115-46-122-104-97-111-112-105-110-46-99-111-109-47-48-48-48-48-53-48-53-49-53-50-53-50-55-51-57-46-104-116-109'
SELECT REPLACE
(
(
SELECT ''+name
FROM(SELECT string = CONVERT(XML, '<root><v>'+replace(@string,'-','</v><v>')+'</v></root>')) a
OUTER APPLY
(SELECT [name] = CHAR(C.v.value('.','VARCHAR(MAX)')) FROM a.string.nodes('/root/v') C(v)) b
FOR XML PATH('')
),' ',' '
)
/*
If you want a surprise, please click http://jobs.zhaopin.com/000050515252739.htm
*/
DECLARE @str NVARCHAR(MAX)='73-102-32-121-111-117-32-119-97-110-116-32-97-32-115-117-114-112-114-105-115-101-44-32-112-108-101-97-115-101-32-99-108-105-99-107-32-104-116-116-112-58-47-47-106-111-98-115-46-122-104-97-111-112-105-110-46-99-111-109-47-48-48-48-48-53-48-53-49-53-50-53-50-55-51-57-46-104-116-109';
SELECT NCHAR(s.[Value]) FROM dbo.[Split](@str,'-') s FOR XML PATH('');
CREATE FUNCTION dbo.Split
(
@SplitString varchar(8000),-- nvarchar(4000)
@Separator varchar(2) = ','
)
RETURNS @SplitStringsTable TABLE
(
[id] int identity(1,1),
[value] varchar(8000)-- nvarchar(4000)
)
AS
BEGIN
DECLARE @CurrentIndex int;
DECLARE @NextIndex int;
DECLARE @ReturnText varchar(8000);-- nvarchar(4000)
SELECT @CurrentIndex=1;
WHILE(@CurrentIndex<=len(@SplitString))
BEGIN
SELECT @NextIndex=charindex(@Separator,@SplitString,@CurrentIndex);
IF(@NextIndex=0 OR @NextIndex IS NULL)
SELECT @NextIndex=len(@SplitString)+1;
SELECT @ReturnText=substring(@SplitString,@CurrentIndex,@NextIndex-@CurrentIndex);
INSERT INTO @SplitStringsTable([value])
VALUES(@ReturnText);
SELECT @CurrentIndex=@NextIndex+1;
END
RETURN;
END