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
- 11837 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
Can we update data in a view?
Can you name some of the dml commands in sql?
What is a performance monitor?
How to link tables in sql server?
What is Dependency Injection and provide example?
Tell me something about security and sql azure?
How do I get Report Builder to generate a parameter that can be set by users viewing the report?
How to write character string constants or literals in ms sql server?
How do I open port 1433?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
what are the disadvantages of cursors? : Sql server database administration
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is raid and what are different types of raid levels?
What is isnull() operator?
What is the difference between for xml raw and for xml auto?
