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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 updating an array

Author  Topic 

Inno
Starting Member

33 Posts

Posted - 2010-12-21 : 09:14:48
I have a cloumn that is an array and want to replace it with another array values. I cant get the syntax right.

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-12-21 : 09:32:10
Neither can we until you post an example of your table structure, existing data, and expected results.
Go to Top of Page

Inno
Starting Member

33 Posts

Posted - 2010-12-21 : 09:34:19
I have a column X
and I want to put values 'article','description','quality' into the column X in one field
Go to Top of Page

robvolk
Most Valuable Yak

15732 Posts

Posted - 2010-12-21 : 10:00:27
UPDATE myTable SET X='article,description,quality'
Go to Top of Page
   

- Advertisement -