Will SQL Server 2014 Support to Read BLOB (Byte Array)
-
Similiar thing for flaot values can we get..!
for decimal values is it is possible...
Select utl_raw.cast_to_varchar2(utl_raw.CAST_FROM_BINARY_FLOAT(.2635)) from dual;
>†éy
-
David Burrows (12/19/2013)
DECLARE @test varchar(max)
SET @test = CHAR(1)+CHAR(87)+CHAR(179)
SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)
how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a dynamic one then how will u do
how to do it for vice versa...
Thanks for your suggestion..!
-
yuvipoy (12/23/2013)
David Burrows (12/19/2013)
DECLARE @test varchar(max)
SET @test = CHAR(1)+CHAR(87)+CHAR(179)
SELECT CAST(CAST(SUBSTRING(@test,1,3) as varbinary(3)) as int)
how do u made CHAR(1)+CHAR(87)+CHAR(179) on which factor u decide if it is a dynamic one then how will u do
how to do it for vice versa...
Thanks for your suggestion..!
If you would post a couple of rows of data and tell us what they contain, this could be all over in a minute or two.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Pasting couple of rows is not a problem but what is the logic...?
-
yuvipoy (12/26/2013)
Pasting couple of rows is not a problem but what is the logic...?Post the couple of rows and tell me what's in them and then we'll see what we can do.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Viewing 5 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply