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
- 9699 Views
- Value Labs, I also Faced
- E-Mail Answers
Answer Posted / anand k
Hi,
Yoy didn't mention the datatype of the column "phone
number"
prob the varchar datatype has used to the phno.
update <tablename>
set phno = cast(0 as varchar(1)) + phno
| Is This Answer Correct ? | 16 Yes | 1 No |
Post New Answer View All Answers
Difference Between ORDER BY Clause and GROUP BY Clause in SQL?
What is the tcp/ip port on which sql server runs?
How can you tell if a database object is invalid?
What is sql server english query?
How do I schedule a sql server profiler trace?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
How to create a user name in a database?
Explain the use of containers in ssis and also their types?
Other than truncate statement, which other command can by-pass the trigger on the tables?
How to delete an existing row with delete statements in ms sql server?
Differentiate between a primary key and a unique key.
Differentiate between SQL and ORACLE joins and write their syntax.
What are the diifferences between the ms sql server vs mysql?
What is a full text index?
What are the basic functions for master, msdb, model, tempdb databases?
