Arrays in SQL?
Posted on 2008-06-26
I am aware there are no arrays in SQL. Instead we use tables (read it online).
here is my situtation: I want to be able to make a link between a business we service and a category of colors for their logos.
business 1 might have red and blue
business 2 might have Green and blue
business 3 might have red
business 4 might have Yellow and blue
I have the Category table
cat ID cat name
I also have a cat_business Table...
I am adding the buisness through a asp.net 2.0 form and I have check boxes for the colors...
I know how to get the check boxes selected...
My question is how can I go about to add them to the database...
I want to add them when I add the business in my stored procedure...
Any help would be great.