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
- 11785 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
What is Federation and Federation Member?
How to enter binary string literals in ms sql server?
Explain the rules for designing files and file groups in sql server?
Explain what are magic tables in sql server?
Define outer join in sql server joins?
What are the steps you should follow to start sql server in single-user mode?
What are the properties of primary key?
What are the steps to take to improve performance of a poor performing query? : sql server database administration
what are defaults? : Sql server database administration
How to rename an existing table with the "sp_rename" stored procedure in ms sql server?
User wants only to display only pdf as export option in report manager. How to achieve this?
Name 3 ways to get an accurate count of the number of records in a table?
What should be the fill factor for indexes created on tables? : sql server database administration
Explain multiserver query
what are user defined datatypes and when you should go for them? : Sql server database administration
