Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @binvalue binary(4)
- SET @binvalue = 0x12345678
- PRINT CAST(@binvalue AS nvarchar)
- print master.sys.fn_varbintohexstr(@binvalue)
- DECLARE @binvalue binary(4)
- SET @binvalue = 0x61000000
- PRINT @binvalue
- PRINT cast('a' AS binary(4))
- PRINT cast(0x61 AS varchar)
- DECLARE @mybin1 binary(16)
- DECLARE @s varchar(100)
- SET @mybin1 = 0x098F6BCD4621D373CADE4E832627B4F6
- SET @s = 'The value of @mybin1 is: ' + sys.fn_varbintohexsubstring(0, @mybin1,1,0)
- PRINT @s
- sp_helptext 'fn_varbintohexsubstring'
Add Comment
Please, Sign In to add comment