Sunday, February 19, 2012

array

How do you define an array of varchar in a table and how do you manupiluate
it? Thanks.00KobeBrian wrote:
> How do you define an array of varchar in a table and how do you manupiluate
> it? Thanks.
There is no array type in SQL Server. It makes sense to eliminate any
arrays from your logical model, i.e. use a table for a set of varchar
values instead of an array.
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--

No comments:

Post a Comment