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
- 11486 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
How you can get a list of all the table constraints in a database?
What is log shipping? Can we do logshipping with SQL Server 7.0 - Logshipping is a new feature of SQL Server 2000. We should have two SQL Server - Enterprise Editions. From Enterprise Manager we can configure the logshipping. In logshipping the transactional log file from one server is automatically updated into the backup database on the other server. If one server fails, the other server will have the same db and we can use this as the DR (disaster recovery) plan.
How to create an multi-statement table-valued function?
What is catalog views?
Explain about SQLOS?
What is the difference between TRUNCATE and DROP?
Scalability, Availability, Integration with internet, etc.)?
What are clustered and non-clustered index?
When does a workload on SQL Azure get throttled?
What is sql server programming?
What is the difference function and stored procedure?
What is usually the first word in a sql query?
Tell me extended events in sql server 2008?
Can you edit the .rdl code associated with a linked report?
Explain the collation?
