SELECT LEN(REPLICATE( 'C', 5000)) returns 5000 then What is the output of SELECT LEN(REPLICATE( 'C', 10000)) ?

 Posted by Bandi on 9/12/2013 | Category: Sql Server Interview questions | Views: 2995 | Points: 40
Select from following answers:
  1. 10000
  2. 8000
  3. 5000
  4. None of the above
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Posted by: Bhaumik50 on: 9/18/2013 | Points: 10
Answer is 2. : 8000. REPLICATE function truncate the value more than 8000 bytes and returns 8000
Posted by: Schatak on: 10/17/2013 | Points: 10
8000

Login to post response