Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
SQL Server 2012 - what is the output of below query ?
SELECT CONCAT(' 23 Gandhi Nagar', NULL ,'BGLR' ,'KRNTK', '9876')
on 6/26/2015 | Category:
Sql Server Interview questions
| Views: 488 |
Select from following answers:
23 Gandhi NagarBGLRKRNTK9876
23 Gandhi Nagar BGLR KRNTK 9876
23 Gandhi Nagar BGLRKRNTK9876
The CONCAT string function concatenates variable/constants into a single string. NULL values, regardless of the setting of the CONCAT_NULL_YIELDS_NULL, are implicitly converted to an empty string.
Show Correct Answer
Many Interviews |
< Previous :
SQL Server 2012 - what is the data type of output ...
Next > :
Which of the following creates index automatically ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following creates index automatically in database?
Which type of recovery model doesn't log any type of changes?
In which type od index, the bottom level of an index doesn’t contain d ...
Which type of cursor doesn't locks the records/rows that are read ...
With which type of SQL server recovery model are all db changes logged ...
Which of the following refers to the SQL Server transaction isolation ...
In SQL server, which of the following makes a copy of the changes that ...
Which of the following is a way to create and modify tables using SQL ...
Latest Interview Questions
What are HttpHandlers and HttpModules in ASP.NET?
Which one of the following is used to obtain performance information a ...
Which of the following is the fastest way to concat strings in ASP.NET ...
____________ is the Microsoft IIS server running , handling ASP.NET re ...
Which of the following object encapsulates the state of client and the ...
Which one of the following is the type of assembly that contains local ...
When does garbage collector runs ?
__________ is the first method that is fired during the page load ?