I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz...
- 7 Answers
- 9691 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / mechinenirao
update <tablename>
set Phno = '0' + phno
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What are sp_configure commands and set commands?
What is the difference between dbcc indexdefrag and dbcc reindex?
where can you add custom error messages to sql server? : Sql server administration
What are the different types of backups avaialabe in sql server 2005?
Explain the flow of creating a cube? : sql server analysis services, ssas
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
Can you tell me some of the common replication dmv's and their use? : sql server replication
What are recommended options to be used while using db mirroring? : sql server database administration
What does COMMIT command do?
What is report snapshot in ssrs?
optimization techinques
How many ways to create table-valued functions?
What is the web service used for reporting services?
what are the different ways to return the rowcount of a table?
Does the unique constraint create an index?
