Oracle to SQL Server Code Conversion

[nljoco]

How will convert the following Oracle statement into an SQL Server?

TYPE array_of_double IS VARRAY(10) OF DOUBLE PRECISION;

 

[jhall156]

I think you could use...

DECLARE @ArrayOfDouble table(myDouble real)

If using a table variable would satisfy your needs. This is only currently in SQL Server 2000.
I started out with nothing, and I still have most of it.

 

[tlbroadbent]

SQL Server currently has no array variables. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[jhall156]

But if you're running SQL Server 2000 you could use a table variable to simulate a 2 dimensional array. I started out with nothing, and I still have most of it.