Creating Arrays in Tables

Hot Topic

How to insulate the client from poor network reliability?
Transactions across WebServices
vb2005-access connection string
Trouble with XPath expressions.
Get Class and property name form an instance property
Migration from 1.1 to 2.0b2 - Could not load type 'SingleTagSectionHandler' from assembly 'System.Configuration'
SocketStream Comunication is not working in the release mode
A Question on GC
I dont khow how to display the XML file "professional" way
problem of c structure in .net

.NET Development

very new and unexpected Error with database
System.UnauthorizedAccessException
Terminating Processes from a Windows Service Cleanly (c#).
Slow regexp for first time match
jpg file information
Connecting to a database and parameters in sql
Using transactions with TableAdapters
Reg the SQLBulkCopy Class
Installing and running IIS in WinXP Home edition
configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

Creating Arrays in Tables

How do I create an array in a SQL database table

Any advice would be very much appreciated.

Answer this question

Creating Arrays in Tables

  • Volcom98

    For small tables, I pack the array of values into a comma-(or whatever)-delimited string. It's not very efficient or elegant. A BLOB (big chunk o' binary) is not a bad idea, if you can parse the BLOB efficiently. The best answer might depend on the data types in the array.

    ---Mike

  • aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

    I don't know aof a way create an array column in an MS SQL Server database, unless you had an array and inserted it as a BLOB coumn to do that but I wouldn't recommend it.

    The correct (relational DB) thing to do (in my opinion) would be to design perhaps two tables.  One table with one being the one table and another as the many table.

    I'm probably way off base because I don't do COBOL.

    HTH

  • zut

    I know this is either a very easy or impossible question but would appreciate if someone could at least give me an indication of which.  I am new to SQL databases after using COBOL index sequential files for years and just need to know if it is possible to create an array within a table and if so how.
  • Creating Arrays in Tables
Answer this question