you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required
- 3 Answers
- 3895 Views
- I also Faced
- E-Mail Answers
Answer Posted / monal
TRY THIS:
SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME'
| Is This Answer Correct ? | 7 Yes | 1 No |
Post New Answer View All Answers
How do you clear a log file?
What are the disadvantages of using querystrings to send data from one page to another?
What are the purpose of Normalisation?
What is the contrast between sql and mysql?
Which are the new data types introduced in sql server 2008?
Recommend an approach to ensuring that all changes in the remote databases synchronize with the SQL Azure database?
What are 3 ways to get a count of the number of records in a table?
What is a with(nolock)?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How to modify the underlying query of an existing view?
what are the reporting service components in SSRS?
Can foreign key be deleted?
How many types of attribute relationships are there? : sql server analysis services, ssas
what are the critical issues you have resloved in your company
What is the use of =,==,=== operators?
