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
- 11829 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / mechinenirao
update <tablename>
set Phno = '0' + phno
| Is This Answer Correct ? | 2 Yes | 4 No |
Post New Answer View All Answers
What is the return type of executeupdate ()?
What is normalization of database? What are its benefits?
Can you explain what is sql server english query?
Explain isolation levels that sql server supports?
What is recompile sql server?
What are sql azure firewall rules?
tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
What are the types of subquery?
What does it mean if @@cursor_row returns a negative number?
How to sort the query output with order by clauses in ms sql server?
Explain aggregate functions?
What is data source object?
What are the main differences between #temp tables and @table variables and which one is preferred?
Can we call future method from queueable?
What are points to remember while using the fillfactor argument?
