Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-03-17 : 08:08:34
|
| Michele writes "Is it possible to create an array column within MS SQL? I am referring to a feature in Postgres SQL that I am unable to find in MS SQL. In Postgres SQL, you can append a pair of square brackets to the data type of the array column within the CREATE TABLE statement. The brackets indicate that more than a single value may be inserted into the column." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2005-03-17 : 08:09:35
|
| Nope. SQL Server 2005 would allow this with the new CLR user-defined types, but the current versions do not. Also, it violates relational theory to store more than one value in one column. Practically speaking, it becomes extremely inefficient and complicated to extract multiple values from a column, vs. storing the values as multiple rows in a table. PostGres might handle it well, but SQL Server and many other databases do not. |
 |
|
|
|
|
|
Create an Array Column