sqlconvert:SQL Server: convert varbinary to varchar来源: 发布时间:星期二, 2008年12月23日 浏览:2次 评论:0
="t18">Use CAST or CONVERT
select convert (varbinary (20) , "select") it gives = 0x73656c656374 then you can convert that to a varchar select convert (varchar (20), 0x73656c656374 ) it gives "select" Use master.dbo.fn_varbohexsub(1,@binvalue,1,0) master.dbo.fn_varbohexsub(1,@binvalue,1,0) declare @binvalue varbinary(256), @vcharvalue nvarchar(256) @binvalue = 0xF5FF3FED3B055DF7EC27251FBC80EE48 select @vcharvalue = 'aa' + master.dbo.fn_varbohexsub(1,@binvalue,1,0) pr @vcharvalue it gives = 0xF5FF3FED3B055DF7EC27251FBC80EE48 Use master.dbo.fn_varbohexstr(@binvalue) declare @binvalue varbinary(256), @vcharvalue nvarchar(256) @binvalue = 0xF5FF3FED3B055DF7EC27251FBC80EE48 select @vcharvalue = 'aa' + master.dbo.fn_varbohexstr(@binvalue) pr @vcharvalue it gives = 0xF5FF3FED3B055DF7EC27251FBC80EE48 http://www.cnblogs.com/skyfei/archive/2006/09/13/502861.html 0
相关文章
读者评论
发表评论 |