Prev: Triggers after Insert
Next: Execute job from osql
From: Francis Baiden on 12 Jun 2010 07:37
hello guys,

can someone show me how to create an array variable in an MSSQL database.

Thank u.

Francis
From: John Bell on 12 Jun 2010 10:13
On Sat, 12 Jun 2010 11:37:38 -0000, "Francis Baiden"
<joebaiden1(a)yahoo.com> wrote:

>hello guys,
>
>can someone show me how to create an array variable in an MSSQL database.
>
>Thank u.
>
>Francis

There isn't an array variable type in SQL Server, although there are
table variables which are available in SQL 2005 and higher versions.

You can also look at http://www.sommarskog.se/arrays-in-sql.html

John
From: Francis Baiden on 13 Jun 2010 15:21
hi,

Thanks for the reply. I will have to find another way of capturing those
data I wished there were in an array variable.

Francis

"John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
news:oh47161apu4i6aj5v67p5dp1q7s3sopphf(a)4ax.com...
> On Sat, 12 Jun 2010 11:37:38 -0000, "Francis Baiden"
> <joebaiden1(a)yahoo.com> wrote:
>
>>hello guys,
>>
>>can someone show me how to create an array variable in an MSSQL database.
>>
>>Thank u.
>>
>>Francis
>
> There isn't an array variable type in SQL Server, although there are
> table variables which are available in SQL 2005 and higher versions.
>
> You can also look at http://www.sommarskog.se/arrays-in-sql.html
>
> John

From: John Bell on 16 Jun 2010 03:49
On Sun, 13 Jun 2010 19:21:45 -0000, "Francis Baiden"
<joebaiden1(a)yahoo.com> wrote:

>hi,
>
>Thanks for the reply. I will have to find another way of capturing those
>data I wished there were in an array variable.
>
>Francis
>
>"John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
>news:oh47161apu4i6aj5v67p5dp1q7s3sopphf(a)4ax.com...
>> On Sat, 12 Jun 2010 11:37:38 -0000, "Francis Baiden"
>> <joebaiden1(a)yahoo.com> wrote:
>>
>>>hello guys,
>>>
>>>can someone show me how to create an array variable in an MSSQL database.
>>>
>>>Thank u.
>>>
>>>Francis
>>
>> There isn't an array variable type in SQL Server, although there are
>> table variables which are available in SQL 2005 and higher versions.
>>
>> You can also look at http://www.sommarskog.se/arrays-in-sql.html
>>
>> John

Hi Francis

It's not clear if you are wishing to pass the array or not? If you are
passing the array then look at Table Value Parameters for SQL 2008 or
XML in 2005/8 as an alternative to a delimited list. If not then you
may want to post some code as arrays are usually necessary.

John
 | 
Pages: 1
Prev: Triggers after Insert
Next: Execute job from osql