Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 11810 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / khalid moin
update <tablename>
set <column name>='0'||<coulmn name>;
this query will update the values present in column with
prefix 'o'
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
List out what other servers you can use with ssrs?
What is the difference between commit and rollback?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Can you insert NULL in unique column?
What are the 7 disadvantages to a manual system?
How to execute multiple stored procedures at one time in sql server?
How to create a new table in a given schema?
What are the methods used to protect against sql injection attack?
How can you find out which stored procedures are recompiling?
What are the steps you must follow to hide sql server instances?
What is multilevel indexing?
Explain features and concepts of analysis services?
Indexes are updated automatically is the full-text index also updated automatically?
What is normalization? Explain different forms of normalization?
What is difference between inner join and join?
