Monday, August 06, 2012 10:02 AM
I am using SQL Server 2008 R2.
I have the Sotres procedure which resturns more than 30000 rows.
I used VARCHAR(MAX) datatype but its returning nearly 27000 rows. I am missing rest rows.
What data type to be used?
What should be done in this case ?
Monday, August 06, 2012 10:30 AM
Are you saying you are exceeding 2^31-1 bytes? You can try table data type but performance reasons table data type isn't used for >100 rows.
Can you also give little more details about what are you trying to attain?
Monday, August 06, 2012 10:35 AMVarchar(max) can handle bytes (2,147,483,647 bytes or 2GB - 1 bytes) which means 2 GB of data, is your query execeeding 2 GB of data ?
Ramesh Babu Vavilla MCTS,MSBI
Monday, August 06, 2012 10:45 AMAnswerer