datatype for storing a file

Posted by Packs under Sql Server on 9/10/2012 | Points: 10 | Views : 763 | Status : [Member] | Replies : 1
Hello;
In an interview i was asked that if u wan to store a file in DB what datatype will u use..???
can u please let me know the answer for the question.
Thanks in Advance..!!




Responses

Posted by: Tamilarasu on: 9/10/2012 [Member] Starter | Points: 25

Up
0
Down
Hi
In Sql Server
using -- varbinary(max) we can store 2 GB of data
using -- varbinary(n) stores only 8000 bytes

Thanks,
Tamilarasu

Work Hard To Work Good !... .. ...

Packs, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response