If my application was designed to generate a "schedule" or list of dates, and I wanted to store those dates in a SQL server as an array, what SQL data type would I pick? ntext seems excessive, and I don't think date would work...any suggestions?
zachattack05
70
Posting Pro in Training
Recommended Answers
Jump to PostThere is many options. If you want to save as DateTime, you will not be able to save as an array. Because only one value of dateTime can be stored into one cell.
You can choose a varChar - that means converting dateTime values into a string, and seperated …
All 3 Replies
Mitja Bonca
557
Nearly a Posting Maven
skatamatic
371
Practically a Posting Shark
zachattack05
70
Posting Pro in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.