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
- 12070 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / goutham
update <table name>
set column = '0' + ph no:
| Is This Answer Correct ? | 3 Yes | 6 No |
Post New Answer View All Answers
How to update muliple row in single query?
How can I check that whether automatic statistic update is enabled or not?
What is difference between inner join and full join?
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
How can we rewrite sub-queries into simple select statements or with joins?
what are the disadvantages of cursors? : Sql server database administration
What do you understand by triggers and mention the different types of it?
Write an sql query to find first weekday of the month?
What types of Joins are possible with Sql Server?
What do we need queues in sql service broker?
What is the difference between commit and rollback?
What are different types of collation sensitivity?
what are the reporting service components in SSRS?
What are the drawbacks of reporting in ssrs?
Do you know what guidelines should be followed to help minimize deadlocks?
