question

Sanooj avatar image
Sanooj asked

Implementing Arrays in SQL

Hello,

I am trying to migrate from Oracle to SQL Server 2008 and I have run into an issue in trying to emulate Oracle arrays. I know that SQL Server 2008 supports table valued parameters but they are only read-only. The other option would be to use temp or permanent tables. I am ok with this but my concern is on whether I would be able to return these tables back to the calling application which is a .NET application. If I were to use temp/permanent tables, how should I be passing in the tables from the .NET code ?

Any help would be much appreciated.

Thanks,

Sanooj

migration
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.