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
- 11793 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / rajshekar
update <tablename>
set phno=cast (0 as datatype(1))+phno
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
What is a livelock?
Explain about system database?
What is sleeping status in sql server?
How to execute multiple stored procedures at one time in sql server?
Why use view instead of a table?
Can we insert data if clustered index is disabled?
What is the fillfactor concept in indexes?
How to insert data into an existing table?
What is the difference between delete and truncate statements?
Why transaction is important?
What is difference between primary key and foreign key?
How do I install only the client tools of sql server 2000?
How do I edit a procedure in sql server?
Difference between primary key and clustered index?
Why we use trigger in sql server with example?
