Office Document APIs for .NET
ITIL Career Advice
PMP Career Advice
Android Intel XDK
Welcome Guest !
A Customers table has columns names as firstname and lastname. Which of the following function could you use to get the first initial and their last name in the result set?
on 11/24/2013 | Category:
Sql Server Interview questions
| Views: 4897 |
Select from following answers:
SUBSTRING function can be used to get the substring of a string. So we can use this function to get the first character from firstname and then concatenate last name to it
Show Correct Answer
Many Interviews |
< Previous :
What is wrong with the T-SQL batch statement below ...
Next > :
Which of the following is FALSE regarding PRIMARY ...
Comments or Responses
Login to post response
More Interview Questions by Bandi
Which of the following is FALSE regarding PRIMARY KEYS in SQL Server 2 ...
How to enforce rules for the type of information that can be stored in ...
Which of the following transaction isolation levels is the default in ...
Which of the following is FALSE regarding DML triggers?
If you have ON DELETE CASCADE statement to the foreign key relationshi ...
SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'study'), ...
How to limit the results to include only the top 100 most recent recor ...
CREATE TABLE employee ( id_num int IDENTITY(100,10), fname varchar (20 ...
Latest Interview Questions
Which statement is False about Optional parameters in VB.Net?
How to get Row Index in MySQL?
How to get Table row no/row index in sql-server.
In case we are returning anonymous type from Controller to the views, ...
How many ways to compare String values in Dot Net?
In Gridview' RowEditing event, what piece of code should be writte ...
In Gridview' RowCancelingEdit event, what piece of code should be ...