Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 4902 Views
- I also Faced
- E-Mail Answers
Answer Posted / radhakrishnan
select replace('radha krishnan',' ','-')
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is indexing in sql server with example?
if no size is defined while creating the database, what size will the database have? : Sql server administration
How to set the current database in ms sql server?
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What happens if you are trying to access a schema not owned by you?
What is the cartesian product of the table?
What is an etl file?
What are the disadvantages of using the stored procedures?
How to download and install sql server 2005 books online?
How do you use a subquery to find records that exist in one table and do not exist in another?
What are the restraints imposed on the table design by a merge replication?
How do I view a stored procedure in sql server?
As a general practice, it is recommended to have dbo be the owner of all database objects however, in your database you find number of tables owned by a user other than dbo, how could you fix this?
How do I find information about the install locations for the various instances running on a computer?
Can you please explain the difference between primary keys and foreign keys?
