Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
SELECT LEN(REPLICATE( 'C', 5000)) returns 5000 then What is the output of SELECT LEN(REPLICATE( 'C', 10000)) ?
on 9/12/2013 | Category:
Sql Server Interview questions
| Views: 2995 |
Select from following answers:
None of the above
Syntax of REPLICATE() is:
REPLICATE (string_exp, numOfTimes)
If string_expression is NOT of type varchar(max) or nvarchar(max), REPLICATE truncates the return value at 8,000 bytes.
Ex: In REPLICATE( 'C', 10000) statement, first argument is of type VARCHAR but not the VARCHAR(MAX). That is the reason REPLICATE truncates return value at 8000 characters
Show Correct Answer
Many Interviews |
< Previous :
can we use script manager in .aspx page if it is a ...
Next > :
To rollback a PORTION of a transaction, What We ha ...
Comments or Responses
on: 9/18/2013 |
Answer is 2. : 8000. REPLICATE function truncate the value more than 8000 bytes and returns 8000
on: 10/17/2013 |
Login to post response
More Interview Questions by Bandi
To rollback a PORTION of a transaction, What We have to define .... ?
Why sometimes "NOT IN condition" will return NO results even ...
How to join two tables without having common column between them?
What are the Different ways of importing data into SQL Server?
How to do custom sorting in SQL Server?
Which statement is correct to display FruitNames of the table(Fruit) i ...
Difference between PARSE() and TRY_PARSE() functions
Latest Interview Questions
You are creating a custom product class. You want to ease the conversi ...
You want to determine whether the value of an object reference is deri ...
Your developed web app creating a custom exception called LogonFailedE ...
Your developed web application code catches an IOException when a file ...
You are checking the arguments of your method for illegal null values. ...
You are processing some data from over the network. You use a HasNext ...
You have a list of dates. You want to filter the dates to the current ...
You are using a multicast delegate with multiple subscribers. You wa ...