34,576
社区成员
发帖
与我相关
我的任务
分享
declare @s varchar(100)
set @s='ff00ff00ff00ff00ff00'
exec('select cast(cast(0x'+@s+' as varbinary) as nchar)')
/*
------------------------------
ÿÿÿÿÿ
*/
[Quote=引用 7 楼 happyflystone 的回复:]
SQL codedeclare@svarchar(100),@s1nvarchar(100),@s2nvarchar(100),@s3nchar(1),@s4nchar(1),@s5nchar(1),@s6nchar(1),@iintdeclare@sxnchar(6)set@s='ffffffffffff';set@i=0set@s1=''set@s2=N''declare@tnvarchar(1000)while@i<6beginset@t='set @s1 = NCHAR(0x'+substring(@s,@i+1,2)+')'execsp_executesql@t,N'@s1 nvarchar(10) out',@s1outset@s2=@s2+@s1set@i=@i+2endselect@s2/*----------------------------------------…
[/Quote]
declare @s varchar(100),@s1 nvarchar(100),@s2 nvarchar(100),@s3 nchar(1),@s4 nchar(1),@s5 nchar(1),@s6 nchar(1),@i int
declare @sx nchar(6)
set @s='ffffffffffff';
set @i=0
set @s1=''
set @s2=N''
declare @t nvarchar(1000)
while @i <6
begin
set @t = 'set @s1 = NCHAR(0x'+substring(@s,@i+1,2)+')'
exec sp_executesql @t,N'@s1 nvarchar(10) out',@s1 out
set @s2 = @s2 +@s1
set @i=@i+2
end
select @s2
/*
----------------------------------------------------------------------------------------------------
ÿÿÿ
*/