Sql update array

The Plankmeister. Hi there The information I can find about it seems to say that it has to be an array created inside the query, but if it's a stored procedure, this isn't possible, is it? Hope someone can help Follow Post Reply. Simon Hayes. I don't know about Access, but for SQL Server, one possible way would be to parse the arrays on the client side, then call a stored procedure multiple times: exec dbo.

MyProc 'a', 1 exec dbo. MyProc 'b', 2 etc. Alternatively, you could look at transforming the arrays into a two-column table, then join on it: update dbo.

Services Consulting Education Modernization Outsourcing. Characters Remaining: Please provide feedback! Printable View. URL Name P Article Number Steps to Reproduce.

This example illustrates the usage of one-dimensional array elements in searching database tables. This example illustrates the usage of multidimensional array elements in searching database tables. The above examples are very helpful if we know the size or the location of attributes in an array.

But they become very tedious once the size of the array becomes large. So, what to do to avoid such situations? The above-mentioned SQL queries can be alternatively written as follows. We can observe that the results of both the queries are the same. An array is a data structure that stores elements of the same built-in data-type in a contiguous memory location.

Find centralized, trusted content and collaborate around the technologies you use most. Connect and share knowledge within a single location that is structured and easy to search. The elements of the array relates to columns in the table. Element[0] relates to column1, Element[1] relates to column2 and Element[2] relates to column3. Element[4] relates to column1 again and so on. I want to match element[0] to values in column1 to identify a particular record and update column 2 and 3 with values of Element[3] and [4].

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more.