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
Answer Posted / radhakrishnan
select replace('radha krishnan',' ','-')
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
How many types of triggers in sql server?
What is default port number for sql server 2000?
Can an automatic recovery be initiated by a user?
Define a cross join?
What are the different types of columns types constraints in the sql server?
Explain in brief how sql server enhances scalability of the database system?
Describe the left outer join & right outer join. : sql server database administration
Detail about query optimizer?
how would you store your query in an SSRS report or a Database server?
What type of locking occurs during the snapshot generation? : sql server replication
What command is used to delete a table from the database in the sql server and how?
What is a coalesce function?
Why do we need normalization?
what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration
What are different types of join?