TRY THIS: SELECT FIRSTNAME +'-'+LASTNAME FROM 'TABLENAME�

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

Question Posted / monal

3 Answers
4882 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

Please Help Members By Posting Answers For Below Questions

Can we insert data if clustered index is disabled?

934

do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration

974

What is cached report?

143

explain what is raid and what are different types of raid configurations? : Sql server database administration

991

Explain mixed authentication mode of sql server?

1046

How many non clustered indexes there can be on table ?

914

How to create a view and a stored procedure in ms sql server using "create view/procedure" statements?

1001

What is subquery? Explain the properties of a subquery?

976

What is a transact-sql statement batch in ms sql server?

1007

What are the system database in sql server 2008?

1025

What is triggers and stored procedures?

935

Explain the concept of recursive stored procedure.

933

Does view occupy space?

933

Can we call future method from trigger?

928

why would you use sql agent? : Sql server database administration

1199