Wednesday, 15 August 2012

database - Is there any datatype that can store data more than 2 gb in sql server -


I need to store more than 2 gigabytes of data in columns. Is there a way I can ? I need the data that I store, should not be in the computer, as a result when using the file stream concept

No is not there. NVRAR (max) is a datatype which can be used to store 2 GB of data in a column. But you can not store more data than 2 GB in its data, so that the datatype has the upper limit.

On one side, note that due to you storing such a large amount of data in the column, there may be a lot more to it than on the display and can not be a worthy thing to move forward with it. I'm sure you can find the options.

Potential options may be to split the data and store it in multiple rows. As has been commented by Malden Prasadik, you can use to store more than 2GB of data.


No comments:

Post a Comment