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
- 9680 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / a
update <table_name> set phno = Convert(int, '0' +
Convert(varchar(10),phno))
| Is This Answer Correct ? | 1 Yes | 3 No |
Post New Answer View All Answers
Explain the microsoft sql server delete command? : SQL Server Architecture
What is the xml datatype?
What are the difference between primary keys and foreign keys?
Why is normalisation important?
Explain the dirty pages?
What is ms sql server service broker?
How to disable a login name in ms sql server?
What are different type of Collation Sensitivity?
What is inline variable assignment?
Do you know what is blocking?
What stored procedure would you use to view lock information?
What is amo? : sql server analysis services, ssas
How you can change a cross join into an inner join?
How to name query output columns in ms sql server?
Explain the xml support sql server extends?
