use array for storing multiple data

[sudhaMurugesan]

Hi,
I am having single column with multiple rows and i want to store all rows into a single variable (like array variable).

For example,
we can use array for storing multiple data in c#. How its possible in Sql Server.