I will cross-post this in the sql server forum also
I have a control that returns me a stream (memorystream) and I wish to store this variable length (possibly sometimes more than 8000 bytes) data in a sql server table.
The question is what colum type should i use (i have seen people mention image and text) and how I actually get the stream into the column ie. I know how all the sql stuff works and I am using a stored proc with parameters so the question is do I need to cast the stream before assigning it to the sql parameter??