Sign in
 
HomeLibraryLearnDownloadsTroubleshootingCommunityForums
SQL Server Developer Center >
> 
> 
Sql Server Datatype size

Unanswered Sql Server Datatype size

  • Monday, August 06, 2012 10:02 AM
     
     
    Sign In to Vote
    0

    Hi

    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 ?

     

All Replies

  • Monday, August 06, 2012 10:30 AM
     
     
    Sign In to Vote
    0

    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 AM
     
     
    Sign In to Vote
    0
    Varchar(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 AM
    Answerer
     
     
    Sign In to Vote
    0
    Are you trying to make a table as one row output? Can you explain what are you trying to achieve?

    Best Regards,Uri Dimant SQL Server MVP,http://sqlblog.com/blogs/uri_dimant/