Storing array of integer values in SQL Server

c# sql sql-server-2005 objectdatasource
spoekes picture spoekes · Oct 27, 2010 · Viewed 20.3k times · Source

i want to store an array of integer values in a SQL database table (SQLServer 2005), if possible by using a single column.

The integer array will have a length of 7560 values.

I am using a objectdatasource, the datatype should be compatible with the generated parameters of a tableadapter.

thanks for helping :)

Answer

Mark Byers picture Mark Byers · Oct 27, 2010

You have at least two choices:

  • Store it as a comma separated list of values.
  • Use a separate table and store one value per row, with a foreign key pointing back to your table.

If you want to normalize your database you should take the second option.

Related questions

What represents a double in sql server?

I have a couple of properties in C# which are double and I want to store these in a table in SQL Server, but noticed there is no double type, so what is best to use, decimal or float? This …

Read More
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)

I am hitting some performance bottlenecks with my C# client inserting bulk data into a SQL Server 2005 database and I'm looking for ways in which to speed up the process. I am already using the SqlClient.SqlBulkCopy (which is based …

Read More
The tail of the log for the database "DBName" has not been backed up

I tried to restore a database using the following query: ALTER DATABASE [DatabaseName] SET Single_User WITH Rollback Immediate GO RESTORE DATABASE DatabaseName FROM DISK = 'C:\DBName-Full Database Backup' ALTER DATABASE [DatabaseName] SET Multi_User GO but instead of restoring …

Read More