Storing Binary Data in SQL Server

In a recent forum message, JohnSub wrote:

"I need to save data into MS SQL Server programatically. The data has to be formatted as an array of bytes. What should the data type for that field be?"

Do you have any advice for John? Interested in solutions to the same problem? Visit the About Databases forum and join the discussion!