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
- 11477 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 are the different types of join?
How to link tables in sql server?
What is the purpose of floor function?
Explain error handling in ssis?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Define clusters?
How do I find the query plan in sql server?
What are the steps to follow to configure SQL*Net?
What is the user of Primary key?
What stored procedure can you use to display the current processes?
What is BLOCK statements in SQL?
how to avoid cursors? : Sql server database administration
Can We Use Data-grids For Our Report In Ssrs?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are the differences between having and where clause.
