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
Do you think BCNF is better than 2NF & 3NF? Why?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
Explain the difference between functions and stored procedures in sql server?
What is self contained multi valued query?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
What are different types of raid configurations? : SQL Server Architecture
Do you know what is xpath?
What is the boxing and unboxing concept in .net?
What is reference section?
Give an example of SQL injection attack ?
In which sql server version report builder introduced?
What objects does the fn_my_permissions function reports on? : sql server security
Can an automatic recovery be initiated by a user?
What are the disadvantages of using the stored procedures?