I need a column in my table that its DataType should be as integer arrays how can I implemant it in my sqlserver table.
Any help appreciated.is it possible at all?I dont want to make another table.
Thanks|||Unfortunately, there are no array data types in SQL Server. If you provide more information we might be able to make suggestions.
Terri|||Thank you Terri for the reply
>>there are no array data types in SQL Server , I got my answer,I will make another table|||you could always create a user defined function that splits a comma delimited string into a @.table or something.|||If the OP provided more info I was going to suggest one of the approaches listed here:How to pass a list of values or array to SQL Server stored procedure?. That blog entry pretty nicely sums up all of the discussions we've had ad nauseum on this topic :-)
Terri
No comments:
Post a Comment