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
- 12060 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
Will count(column) include columns with null values in its count?
What are the types of sql server?
What is sql language?
What are the disadvantages of indexes?
Can I delete event logs?
What is the significance of null value and why should we avoid permitting null values?
Explain nested trigger in sql?
What is subquery? Explain the properties of a subquery?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
Your table has a large character field there are queries that use this field in their search clause what should you do?
How to turn off warning messages during php execution?
What is sql server management studio? : sql server management studio
How do I find the port number for sql server?
How to use subqueries with the in operators in ms sql server?
How to convert a numeric expression from one data type to another?
