How to declare a array list in sql server

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

How To declare a array list in sql server

I have someting like this

select EmailDetailTempId from TableName

It returns a more than one Value so how can i store a more than one value in Array list or Some Variable...

OUTPUT

SQL

VB

Thanks in Advance...

Posted 2-Apr-14 0:22am

Rahul JR

Updated 2-Apr-14 0:32am

v3

Add a Solution

Comments

Keith Barrow 2-Apr-14 6:26am

Can you update your question please, as it stands it doesn't make a lot of sense I think the terminology is confused or (more likely) you've missed some important information.
The select will return [probably] several columns and however many rows in your database, this is how SQL works, so an array list doesn't make sense in this context. Are you executing the SQL from code (e.g. .net/Java) - if so which?
Certainly for .net I wouldn't use an array list as the collection type - I doubt it is still the best choice in Java.

Rahul JR 2-Apr-14 6:32am

Check it... is it ok now? ??

Keith Barrow 2-Apr-14 6:46am

Not really - SQL doesn't have an array list. At a stretch an individual row is like an object instance, columns like properties of the object type and the whole table acts as a list. Additionally, a table is a store, properly written it is the only store for this information.

Can you clarify where you want to "store" the "array list" and what you want to do with the information - normally working on SQL you query against the table directly unless the table is *very* large

Ganesh Raja 2-Apr-14 6:27am

what is the need? can you elaborate your requirement?
instead of using the array list you can declare table and use.

2 solutions

Solution 1

Use a temporary table, and then

SQL

SELECT * INTO #MyTemporaryTable FROM MyTable

Posted 2-Apr-14 0:37am

OriginalGriff

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Raul Iloc · Accepted Answer · 2014-04-02T00:50:00

Solution 2

Array are not possible but you could declare temp table in SQL like this:

SQL

DECLARE @MyArray TABLE(MyID INT);
INSERT INTO @MyArray EmailDetailTempId from TableName

Posted 2-Apr-14 0:50am

Raul Iloc